DBA Data[Home] [Help]

APPS.OTA_TDB_BUS dependencies on PER_BUSINESS_GROUPS

Line 152: from per_business_groups_perf pbg

148: --
149: cursor csr_sec_grp is
150: select pbg.security_group_id,
151: pbg.legislation_code
152: from per_business_groups_perf pbg
153: , ota_delegate_bookings tdb
154: where tdb.booking_id = p_booking_id
155: and pbg.business_group_id = tdb.business_group_id;
156: --

Line 246: from per_business_groups_perf pbg

242: -- Declare cursor
243: --
244: cursor csr_leg_code is
245: select pbg.legislation_code
246: from per_business_groups_perf pbg
247: , ota_delegate_bookings tdb
248: where tdb.booking_id = p_booking_id
249: and pbg.business_group_id = tdb.business_group_id;
250: --

Line 590: from per_business_groups

586: l_legislation varchar2(30);
587: --
588: cursor cur_leg is
589: select legislation_code
590: from per_business_groups
591: where business_group_id=p_business_group_id;
592: --
593: begin
594: --