DBA Data[Home] [Help]

APPS.PAY_PL_PAYE_API dependencies on PER_BUSINESS_GROUPS_PERF

Line 593: , per_business_groups_perf bus

589: cursor csr_get_derived_details is
590: select bus.business_group_id
591: , bus.legislation_code
592: from per_all_assignments_f paf
593: , per_business_groups_perf bus
594: where paf.assignment_id = p_assignment_id
595: and l_effective_date between paf.effective_start_date
596: and paf.effective_end_date
597: and bus.business_group_id = paf.business_group_id;

Line 687: , per_business_groups_perf bus

683: cursor csr_get_derived_details is
684: select bus.business_group_id
685: , bus.legislation_code
686: from per_all_assignments_f paf
687: , per_business_groups_perf bus
688: where paf.assignment_id = p_assignment_id
689: and l_effective_date between paf.effective_start_date
690: and paf.effective_end_date
691: and bus.business_group_id = paf.business_group_id;

Line 802: , per_business_groups_perf bus

798: cursor csr_get_derived_details is
799: select bus.business_group_id
800: , bus.legislation_code
801: from per_all_assignments_f paf
802: , per_business_groups_perf bus
803: where paf.assignment_id = p_assignment_id
804: and l_effective_date between paf.effective_start_date
805: and paf.effective_end_date
806: and bus.business_group_id = paf.business_group_id;

Line 900: , per_business_groups_perf bus

896: cursor csr_get_derived_details is
897: select bus.business_group_id
898: , bus.legislation_code
899: from per_all_people_f papf
900: , per_business_groups_perf bus
901: where papf.person_id = p_person_id
902: and l_effective_date between papf.effective_start_date
903: and papf.effective_end_date
904: and bus.business_group_id = papf.business_group_id;