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_SID_BUS dependencies on PAY_IE_PRSI_DETAILS_F

Line 29: , pay_ie_prsi_details_f sid

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_ie_prsi_details_f sid
30: , per_all_assignments_f paa
31: where sid.prsi_details_id = p_prsi_details_id
32: and sid.assignment_id = paa.assignment_id
33: and pbg.business_group_id = paa.business_group_id;

Line 91: , pay_ie_prsi_details_f sid

87: --
88: cursor csr_leg_code is
89: select pbg.legislation_code
90: from per_business_groups pbg
91: , pay_ie_prsi_details_f sid
92: , per_all_assignments_f paa
93: where sid.prsi_details_id = p_prsi_details_id
94: and sid.assignment_id = paa.assignment_id
95: and pbg.business_group_id = paa.business_group_id;

Line 523: FROM pay_ie_prsi_details_f ipd

519: ) IS
520: -- Select existing PRSI details
521: CURSOR csr_prsi_details IS
522: SELECT min(ipd.effective_start_date) min_start_date
523: FROM pay_ie_prsi_details_f ipd
524: WHERE ipd.assignment_id = p_assignment_id
525: and (ipd.effective_start_date between p_validation_start_date and p_validation_end_date
526: OR ipd.effective_end_date between p_validation_start_date and p_validation_end_date
527: OR p_validation_start_date BETWEEN ipd.effective_start_date and ipd.effective_end_date