DBA Data[Home] [Help]

APPS.HR_GENERAL2 dependencies on PER_BUSINESS_GROUPS

Line 866: from per_business_groups pbg

862: is
863:
864: cursor csr_bg is
865: select 'Y'
866: from per_business_groups pbg
867: where pbg.business_group_id = p_business_group_id
868: and pbg.legislation_code = p_legislation_code;
869:
870: l_exists varchar2(1);

Line 1319: ,per_business_groups_perf bg

1315: ,SUBSTR(per.national_identifier,-4,4) national_identifier
1316: ,per.business_group_id bg_id
1317: FROM per_all_people_f per
1318: ,per_all_assignments_f ass
1319: ,per_business_groups_perf bg
1320: ,hr_locations_all loc
1321: ,hr_all_organization_units org
1322: ,per_addresses adr
1323: WHERE ass.person_id(+) = per.person_id

Line 1748: ,per_business_groups_perf bg

1744: ,SUBSTR(per.national_identifier,-4,4) "NationalIdentifier"
1745: ,per.business_group_id "BusinessGroupId"
1746: FROM per_all_people_f per
1747: ,per_all_assignments_f ass
1748: ,per_business_groups_perf bg
1749: ,hr_locations_all loc
1750: ,hr_all_organization_units org
1751: ,per_addresses adr
1752: WHERE ass.person_id(+) = per.person_id