DBA Data[Home] [Help]

APPS.PER_PGT_BUS dependencies on PER_BUSINESS_GROUPS

Line 29: from per_business_groups pbg

25: -- Declare cursor
26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups pbg
30: , per_gen_hier_node_types pgt
31: where pgt.hier_node_type_id = p_hier_node_type_id
32: and pbg.business_group_id = pgt.business_group_id;
33: --

Line 93: from per_business_groups pbg

89: -- Declare cursor
90: --
91: cursor csr_leg_code is
92: select pbg.legislation_code
93: from per_business_groups pbg
94: , per_gen_hier_node_types pgt
95: where pgt.hier_node_type_id = p_hier_node_type_id
96: and pbg.business_group_id (+) = pgt.business_group_id;
97: --