DBA Data[Home] [Help]

APPS.OTA_NHS_BUS dependencies on PER_BUSINESS_GROUPS

Line 23: from per_business_groups pbg

19: -- Declare cursor
20: --
21: cursor csr_sec_grp is
22: select pbg.security_group_id
23: from per_business_groups pbg
24: , ota_notrng_histories nth
25: where nth.nota_history_id = p_nota_history_id
26: and pbg.business_group_id = nth.business_group_id;
27: --

Line 84: from per_business_groups pbg

80: -- Declare cursor
81: --
82: cursor csr_leg_code is
83: select pbg.legislation_code
84: from per_business_groups pbg
85: , ota_notrng_histories nth
86: where nth.nota_history_id = p_nota_history_id
87: and pbg.business_group_id = nth.business_group_id;
88: --