DBA Data[Home] [Help]

APPS.PAY_PL_SII_API dependencies on PER_BUSINESS_GROUPS_PERF

Line 357: , per_business_groups_perf bus

353: cursor csr_get_derived_details is
354: select bus.business_group_id
355: , bus.legislation_code
356: from per_all_assignments_f paf
357: , per_business_groups_perf bus
358: where paf.person_id = p_assignment_id
359: and l_effective_date between paf.effective_start_date
360: and paf.effective_end_date
361: and bus.business_group_id = paf.business_group_id;

Line 458: , per_business_groups_perf bus

454: cursor csr_get_derived_details is
455: select bus.business_group_id
456: , bus.legislation_code
457: from per_all_assignments_f paf
458: , per_business_groups_perf bus
459: where paf.person_id = p_assignment_id
460: and l_effective_date between paf.effective_start_date
461: and paf.effective_end_date
462: and bus.business_group_id = paf.business_group_id;

Line 559: , per_business_groups_perf bus

555: cursor csr_get_derived_details is
556: select bus.business_group_id
557: , bus.legislation_code
558: from per_all_assignments_f paf
559: , per_business_groups_perf bus
560: where paf.person_id = p_assignment_id
561: and l_effective_date between paf.effective_start_date
562: and paf.effective_end_date
563: and bus.business_group_id = paf.business_group_id;

Line 661: , per_business_groups_perf bus

657: cursor csr_get_derived_details is
658: select bus.business_group_id
659: , bus.legislation_code
660: from per_all_people_f papf
661: , per_business_groups_perf bus
662: where papf.person_id = p_person_id
663: and l_effective_date between papf.effective_start_date
664: and papf.effective_end_date
665: and bus.business_group_id = papf.business_group_id;