DBA Data[Home] [Help]

APPS.HR_ORD_BUS dependencies on PER_BUSINESS_GROUPS

Line 42: from per_business_groups pbg

38: -- Declare cursor
39: --
40: cursor csr_sec_grp is
41: select pbg.security_group_id
42: from per_business_groups pbg
43: , hr_de_organization_links ord
44: where ord.organization_link_id = p_organization_link_id
45: and pbg.business_group_id = ord.business_group_id;
46: --

Line 102: from per_business_groups pbg

98: -- Declare cursor
99: --
100: cursor csr_leg_code is
101: select pbg.legislation_code
102: from per_business_groups pbg
103: , hr_de_organization_links ord
104: where ord.organization_link_id = p_organization_link_id
105: and pbg.business_group_id = ord.business_group_id;
106: --

Line 514: from per_business_groups

510: --
511: cursor c_valid_legislation
512: (p_business_group_id in number) is
513: select null
514: from per_business_groups
515: where business_group_id = p_business_group_id
516: and legislation_code = 'DE';
517: --
518: --