DBA Data[Home] [Help]

APPS.HR_PERSON_API dependencies on PER_BUSINESS_GROUPS_PERF

Line 1263: per_business_groups_perf bgp

1259: )
1260: is
1261: select bgp.legislation_code
1262: from per_people_f per,
1263: per_business_groups_perf bgp
1264: where per.business_group_id+0 = bgp.business_group_id
1265: and per.person_id = c_person_id
1266: and c_effective_date
1267: between per.effective_start_date and per.effective_end_date;

Line 1589: per_business_groups_perf bgp

1585: select bgp.legislation_code
1586: from per_people_f per,
1587: -- per_business_groups bgp -- 6131445
1588: -- where per.business_group_id = bgp.business_group_id
1589: per_business_groups_perf bgp
1590: where per.business_group_id+0 = bgp.business_group_id
1591: and per.person_id = c_person_id
1592: and c_effective_date
1593: between per.effective_start_date and per.effective_end_date;

Line 1913: per_business_groups_perf bgp

1909: select bgp.legislation_code
1910: from per_people_f per,
1911: -- per_business_groups bgp -- 6131445
1912: -- where per.business_group_id = bgp.business_group_id
1913: per_business_groups_perf bgp
1914: where per.business_group_id+0 = bgp.business_group_id
1915: and per.person_id = c_person_id
1916: and c_effective_date
1917: between per.effective_start_date and per.effective_end_date;