DBA Data[Home] [Help]

APPS.HR_GENERAL2 dependencies on PER_BUSINESS_GROUPS

Line 819: from per_business_groups pbg

815: is
816:
817: cursor csr_bg is
818: select 'Y'
819: from per_business_groups pbg
820: where pbg.business_group_id = p_business_group_id
821: and pbg.legislation_code = p_legislation_code;
822:
823: l_exists varchar2(1);

Line 1265: ,per_business_groups_perf bg

1261: ,SUBSTR(per.national_identifier,-4,4) national_identifier
1262: ,per.business_group_id bg_id
1263: FROM per_all_people_f per
1264: ,per_all_assignments_f ass
1265: ,per_business_groups_perf bg
1266: ,hr_locations_all loc
1267: ,hr_all_organization_units org
1268: ,per_addresses adr
1269: WHERE ass.person_id(+) = per.person_id

Line 1693: ,per_business_groups_perf bg

1689: ,SUBSTR(per.national_identifier,-4,4) "NationalIdentifier"
1690: ,per.business_group_id "BusinessGroupId"
1691: FROM per_all_people_f per
1692: ,per_all_assignments_f ass
1693: ,per_business_groups_perf bg
1694: ,hr_locations_all loc
1695: ,hr_all_organization_units org
1696: ,per_addresses adr
1697: WHERE ass.person_id(+) = per.person_id