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_GB_RTI dependencies on PAY_ALL_PAYROLLS_F

Line 530: pay_all_payrolls_f papf ,

526: per_all_assignments_f paaf,
527: per_all_assignments_f paaf1,
528: per_assignment_status_types past,
529: per_assignment_status_types past1,
530: pay_all_payrolls_f papf ,
531: pay_all_payrolls_f papf1,
532: hr_soft_coding_keyflex flex
533: where
534: peo.person_id = p_person_id

Line 531: pay_all_payrolls_f papf1,

527: per_all_assignments_f paaf1,
528: per_assignment_status_types past,
529: per_assignment_status_types past1,
530: pay_all_payrolls_f papf ,
531: pay_all_payrolls_f papf1,
532: hr_soft_coding_keyflex flex
533: where
534: peo.person_id = p_person_id
535: and paaf.person_id = peo.person_id

Line 567: pay_all_payrolls_f papf ,

563: cursor csr_get_start_end_dates(p_eff_date date,p_tax_ref varchar2) is
564: select paaf.effective_start_date,paaf.effective_end_date
565: from
566: per_all_assignments_f paaf,
567: pay_all_payrolls_f papf ,
568: hr_soft_coding_keyflex flex,
569: per_assignment_status_types past
570: where
571: paaf.assignment_id = p_person_rec.assignment_id

Line 1779: pay_all_payrolls_f pay,

1775: from per_all_people_f pap,
1776: per_all_assignments_f asg,
1777: per_assignment_status_types past,
1778: per_periods_of_service serv,
1779: pay_all_payrolls_f pay,
1780: hr_soft_coding_keyflex sck
1781: where pap.person_id between stperson and endperson
1782: and pap.current_employee_flag = 'Y'
1783: and pap.person_id = asg.person_id

Line 1810: pay_all_payrolls_f pay,

1806: pap.person_id person_id, serv.actual_termination_date actual_termination_date
1807: from per_all_people_f pap,
1808: per_all_assignments_f asg,
1809: per_periods_of_service serv,
1810: pay_all_payrolls_f pay,
1811: hr_soft_coding_keyflex sck
1812: where pap.person_id between stperson and endperson
1813: and serv.actual_termination_date is not null
1814: and pap.person_id = asg.person_id

Line 1853: pay_all_payrolls_f papf ,

1849: per_all_assignments_f paaf,
1850: per_all_assignments_f paaf1,
1851: per_assignment_status_types past,
1852: per_assignment_status_types past1,
1853: pay_all_payrolls_f papf ,
1854: hr_soft_coding_keyflex flex
1855: where
1856: peo.person_id = p_person_id
1857: and paaf.person_id = peo.person_id

Line 2066: pay_all_payrolls_f pay,

2062: pap.person_id person_id,asg.effective_start_date effective_start_date
2063: from per_all_people_f pap,
2064: per_all_assignments_f asg,
2065: per_periods_of_service serv,
2066: pay_all_payrolls_f pay,
2067: hr_soft_coding_keyflex sck,
2068: per_people_extra_info ppei
2069: where pap.person_id between stperson and endperson
2070: and pap.person_id =ppei.person_id (+)

Line 3321: pay_all_payrolls_f papf ,

3317: l_eff_date date;
3318: cursor csr_get_start_date is
3319: select paaf.effective_start_date from
3320: per_all_assignments_f paaf,
3321: pay_all_payrolls_f papf ,
3322: hr_soft_coding_keyflex flex,
3323: per_assignment_status_types past
3324: where paaf.assignment_id = asg_id and paaf.effective_end_date = eff_date - 1
3325: and papf.payroll_id = paaf.payroll_id

Line 3350: pay_all_payrolls_f papf ,

3346: cursor csr_get_end_date is
3347: select paaf.effective_end_date
3348: from
3349: per_all_assignments_f paaf,
3350: pay_all_payrolls_f papf ,
3351: hr_soft_coding_keyflex flex,
3352: per_assignment_status_types past
3353: where paaf.assignment_id = asg_id and paaf.effective_start_date = eff_date + 1
3354: and papf.payroll_id = paaf.payroll_id