APPS.PAY_IN_PF_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 345: per_assignments_f paf,

341: pps.pds_information2 efile, -- Termination Reason(EFile)
342: scl.segment12 eps -- EPS on higher employer wages
343: FROM per_people_f ppf,
344: per_person_types ppt,
345: per_assignments_f paf,
346: per_periods_of_service pps,
347: hr_soft_coding_keyflex scl
348: WHERE paf.person_id = ppf.person_id
349: AND paf.period_of_service_id = pps.period_of_service_id

Line 758: ,per_assignments_f asg

754: CURSOR csr_pos(p_person_id VARCHAR2)
755: IS
756: SELECT nvl(pos.name,job.name) name
757: FROM per_all_positions pos
758: ,per_assignments_f asg
759: ,per_jobs job
760: WHERE asg.position_id=pos.position_id(+)
761: AND asg.job_id=job.job_id(+)
762: AND asg.person_id = p_person_id

Line 1351: per_assignments_f paf,

1347: IS
1348: SELECT DISTINCT paa_init.assignment_id
1349: FROM pay_assignment_actions paa_init,
1350: pay_payroll_actions ppa_init,
1351: per_assignments_f paf,
1352: hr_organization_information hoi
1353: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
1354: AND ppa_init.action_type IN ('P','U','I')
1355: AND ppa_init.action_status = 'C'

Line 1387: per_assignments_f paf,

1383: IS
1384: SELECT DISTINCT paa_init.assignment_id
1385: FROM pay_assignment_actions paa_init,
1386: pay_payroll_actions ppa_init,
1387: per_assignments_f paf,
1388: hr_organization_information hoi
1389: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
1390: AND ppa_init.action_type IN ('P','U','I')
1391: AND ppa_init.action_status = 'C'

Line 1434: per_assignments_f paf,

1430: SELECT DISTINCT paa_init.assignment_id
1431: FROM pay_assignment_actions paa_init,
1432: per_periods_of_service pps,
1433: pay_payroll_actions ppa_init,
1434: per_assignments_f paf,
1435: hr_organization_information hoi
1436: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
1437: AND paf.period_of_service_id = pps.period_of_service_id
1438: AND ppa_init.action_type IN ('P','U','I')

Line 1493: per_assignments_f paf,

1489: IS
1490: SELECT DISTINCT paa_init.assignment_id
1491: FROM pay_assignment_actions paa_init,
1492: pay_payroll_actions ppa_init,
1493: per_assignments_f paf,
1494: hr_organization_information hoi
1495: WHERE ppa_init.payroll_action_id = paa_init.payroll_action_id
1496: AND ppa_init.action_type IN ('P','U','I')
1497: AND ppa_init.action_status = 'C'

Line 1902: ,per_assignments_f paf

1898: SELECT paa.assignment_id
1899: ,paa.payroll_action_id
1900: ,paf.person_id
1901: FROM pay_assignment_actions paa
1902: ,per_assignments_f paf
1903: WHERE paa.assignment_action_id = p_assignment_action_id
1904: AND paa.assignment_id = paf.assignment_id
1905: AND ROWNUM =1;
1906:

Line 1915: ,per_assignments_f paf

1911: IS
1912: SELECT TO_NUMBER(SUBSTR(MAX(LPAD(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) run_asg_action_id
1913: FROM pay_assignment_actions paa
1914: ,pay_payroll_actions ppa
1915: ,per_assignments_f paf
1916: WHERE paf.assignment_id = paa.assignment_id
1917: AND paf.assignment_id = p_assignment_id
1918: AND paa.payroll_action_id = ppa.payroll_action_id
1919: AND ppa.action_type IN('R','Q','I','B')

Line 1996: FROM per_assignments_f paf,

1992: CURSOR csr_chk_pf_org(p_pf_org NUMBER ,
1993: p_assignment NUMBER )
1994: IS
1995: SELECT 1
1996: FROM per_assignments_f paf,
1997: hr_soft_coding_keyflex scl
1998: WHERE (to_char(paf.effective_start_date,'Month-YYYY')=to_char(g_end_date,'Month-YYYY')
1999: OR to_char(paf.effective_end_date,'Month-YYYY')=to_char(g_end_date,'Month-YYYY')
2000: OR g_end_date between paf.effective_start_date and paf.effective_end_date)