eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IN_PF_ARCHIVE dependencies on PER_ASSIGNMENTS_F

Line 343: per_assignments_f paf,

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

Line 754: ,per_assignments_f asg

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

Line 1347: per_assignments_f paf,

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

Line 1383: per_assignments_f paf,

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

Line 1430: per_assignments_f paf,

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

Line 1489: per_assignments_f paf,

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

Line 1898: ,per_assignments_f paf

1894: SELECT paa.assignment_id
1895: ,paa.payroll_action_id
1896: ,paf.person_id
1897: FROM pay_assignment_actions paa
1898: ,per_assignments_f paf
1899: WHERE paa.assignment_action_id = p_assignment_action_id
1900: AND paa.assignment_id = paf.assignment_id
1901: AND ROWNUM =1;
1902:

Line 1911: ,per_assignments_f paf

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

Line 1992: FROM per_assignments_f paf,

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