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

Line 1320: pay_all_payrolls_f pay,

1316: cursor csr_get_ni_rpt_asg(c_asg_id number) is
1317: select
1318: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
1319: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei,
1320: pay_all_payrolls_f pay,
1321: hr_soft_coding_keyflex sck
1322: where paaf1.assignment_id = c_asg_id
1323: and paaf1.person_id = paaf2.person_id
1324: and paaf2.assignment_type = 'E'

Line 3854: pay_all_payrolls_f pay,

3850: pap.person_id person_id , asg.assignment_number l_asg_num
3851: from per_all_people_f pap,
3852: per_all_assignments_f asg,
3853: per_assignment_status_types past,
3854: pay_all_payrolls_f pay,
3855: hr_soft_coding_keyflex sck
3856: where pap.person_id between stperson and endperson
3857: and pap.person_id = asg.person_id
3858: and asg.business_group_id +0 = l_business_group_id

Line 3936: pay_all_payrolls_f pay,

3932:
3933: cursor csr_all_actions_after_fps (asg_id number, p_pact_id number) is
3934: select paa.ASSIGNMENT_ACTION_ID asg_act_id from pay_payroll_actions ppa,pay_assignment_actions paa,
3935: per_all_assignments_f paaf,
3936: pay_all_payrolls_f pay,
3937: hr_soft_coding_keyflex sck
3938: where paa.ASSIGNMENT_ID = asg_id
3939: AND paaf.assignment_id = asg_id
3940: AND pay.payroll_id = paaf.payroll_id

Line 3964: pay_all_payrolls_f pay,

3960: FROM pay_assignment_actions paa
3961: , pay_payroll_actions pact
3962: , per_time_periods ptp,
3963: per_all_assignments_f paaf,
3964: pay_all_payrolls_f pay,
3965: hr_soft_coding_keyflex sck
3966:
3967: WHERE paa.assignment_id = asg_id
3968: AND paaf.assignment_id = asg_id

Line 3992: pay_all_payrolls_f pay,

3988:
3989:
3990: cursor csr_all_actions_after_fps_agg (per_id number, p_pact_id number) is
3991: select paa.ASSIGNMENT_ACTION_ID asg_act_id from per_all_assignments_f paaf, pay_payroll_actions ppa,pay_assignment_actions paa,
3992: pay_all_payrolls_f pay,
3993: hr_soft_coding_keyflex sck
3994: where paaf.person_ID = per_id
3995: and paa.assignment_id = paaf.assignment_id
3996: AND pay.payroll_id = paaf.payroll_id

Line 4020: pay_all_payrolls_f pay,

4016: FROM per_all_assignments_f paaf,
4017: pay_assignment_actions paa
4018: , pay_payroll_actions pact
4019: , per_time_periods ptp,
4020: pay_all_payrolls_f pay,
4021: hr_soft_coding_keyflex sck
4022: WHERE paa.assignment_id = paaf.assignment_id
4023: and paaf.person_id = per_id
4024: AND pay.payroll_id = paaf.payroll_id

Line 4057: pay_all_payrolls_f pay,

4053: FROM per_all_assignments_f paaf,
4054: pay_assignment_actions paa
4055: , pay_payroll_actions pact
4056: , per_time_periods ptp,
4057: pay_all_payrolls_f pay,
4058: hr_soft_coding_keyflex sck
4059: WHERE paa.assignment_id = paaf.assignment_id
4060: and paaf.person_id = per_id
4061: AND pay.payroll_id = paaf.payroll_id

Line 4094: pay_all_payrolls_f pay,

4090: FROM per_all_assignments_f paaf,
4091: pay_assignment_actions paa
4092: , pay_payroll_actions pact
4093: , per_time_periods ptp,
4094: pay_all_payrolls_f pay,
4095: hr_soft_coding_keyflex sck
4096: WHERE paa.assignment_id = paaf.assignment_id
4097: and paaf.person_id = per_id
4098: and paaf.assignment_id <> asg_id

Line 4132: pay_all_payrolls_f pay,

4128: cursor csr_get_ni_rpt_asg(c_asg_id number) is
4129: select
4130: distinct paei.assignment_id , fnd_date.canonical_to_date(paei.AEI_INFORMATION2)
4131: from per_all_assignments_f paaf1, per_all_assignments_f paaf2 ,per_assignment_extra_info paei,
4132: pay_all_payrolls_f pay,
4133: hr_soft_coding_keyflex sck
4134: where paaf1.assignment_id = c_asg_id
4135: and paaf1.person_id = paaf2.person_id
4136: and paaf2.assignment_type= 'E'

Line 5400: pay_all_payrolls_f pay,

5396: FROM per_all_assignments_f paaf,
5397: pay_assignment_actions paa
5398: , pay_payroll_actions pact
5399: , per_time_periods ptp,
5400: pay_all_payrolls_f pay,
5401: hr_soft_coding_keyflex sck
5402: WHERE paa.assignment_id = paaf.assignment_id
5403: and paaf.person_id = person_id
5404: AND paa.payroll_action_id = pact.payroll_action_id

Line 5441: pay_all_payrolls_f pay,

5437: select ppa.effective_date,ppa.payroll_action_id,ppa.report_type
5438: from pay_assignment_actions paa,
5439: pay_payroll_actions ppa,
5440: per_all_assignments_f paaf ,
5441: pay_all_payrolls_f pay,
5442: hr_soft_coding_keyflex sck
5443: where paaf.person_id = per_id
5444: AND pay.payroll_id = paaf.payroll_id
5445: and pay.soft_coding_keyflex_id = sck.soft_coding_keyflex_id