SQL to get Time Card Required Information in Fusion HCM
SELECT papf.person_number, paaf.assignment_number, pasgf.time_card_req FROM per_all_people_f papf, per_periods_of_service ppos, per_all_assignments_f paaf, pay_payroll_assignments ppa, pay_pay_relationships_dn pprd, pay_assigned_payrolls_dn papd, pay_assigned_payrolls_f pasgf WHERE ppos.person_id = papf.person_id AND paaf.person_id = ppos.person_id AND paaf.period_of_service_id = ppos.period_of_service_id AND paaf.assignment_id = ppa.hr_assignment_id AND papd.payroll_term_id (+) = ppa.payroll_term_id AND ppa.payroll_relationship_id = pprd.payroll_relationship_id AND paaf.work_terms_assignment_id = ppa.hr...