DBA Data[Home] [Help]

APPS.PAY_IPD_BUS dependencies on PAY_IE_PAYE_DETAILS_F

Line 29: , pay_ie_paye_details_f ipd

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , pay_ie_paye_details_f ipd
30: , per_all_assignments_f paa
31: where ipd.paye_details_id = p_paye_details_id
32: and ipd.assignment_id = paa.assignment_id
33: and paa.business_group_id = pbg.business_group_id;

Line 91: , pay_ie_paye_details_f ipd

87: --
88: cursor csr_leg_code is
89: select pbg.legislation_code
90: from per_business_groups pbg
91: , pay_ie_paye_details_f ipd
92: , per_all_assignments_f paa
93: where ipd.paye_details_id = p_paye_details_id
94: and ipd.assignment_id = paa.assignment_id
95: and paa.business_group_id = pbg.business_group_id;

Line 636: FROM pay_ie_paye_details_f ipd

632: ) IS
633: -- Select existing PAYE details
634: CURSOR csr_paye_details IS
635: SELECT min(ipd.effective_start_date) min_start_date
636: FROM pay_ie_paye_details_f ipd
637: WHERE ipd.assignment_id = p_assignment_id
638: and (ipd.effective_start_date between p_validation_start_date and p_validation_end_date
639: OR ipd.effective_end_date between p_validation_start_date and p_validation_end_date
640: OR p_validation_start_date BETWEEN ipd.effective_start_date and ipd.effective_end_date