DBA Data[Home] [Help]

APPS.HR_ORU_BUS dependencies on PER_BUSINESS_GROUPS

Line 28: from per_business_groups pbg

24: -- Declare cursor
25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , hr_all_organization_units oru
30: where oru.organization_id = p_organization_id
31: and pbg.business_group_id = oru.business_group_id;
32: --

Line 88: from per_business_groups pbg

84: -- Declare cursor
85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , hr_all_organization_units oru
90: where oru.organization_id = p_organization_id
91: and pbg.business_group_id = oru.business_group_id;
92: --

Line 697: per_business_groups_perf pbg

693: --
694: CURSOR csr_cost_allocation_keyflex_id IS
695: SELECT 'Y'
696: FROM pay_cost_allocation_keyflex pcak,
697: per_business_groups_perf pbg
698: WHERE pcak.cost_allocation_keyflex_id = p_cost_allocation_keyflex_id
699: AND pbg.business_group_id = p_business_group_id
700: AND pbg.cost_allocation_structure = to_char(pcak.id_flex_num);
701: --