DBA Data[Home] [Help]

APPS.HR_CLE_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_de_soc_ins_contr_lvls_f cle
30: , hr_organization_units hou
31: where cle.soc_ins_contr_lvls_id = p_soc_ins_contr_lvls_id
32: and pbg.business_group_id = hou.business_group_id

Line 93: from per_business_groups pbg

89: --
90:
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , hr_de_soc_ins_contr_lvls_f cle
95: , hr_organization_units hou
96: where cle.soc_ins_contr_lvls_id = p_soc_ins_contr_lvls_id
97: and cle.organization_id = hou.organization_id