DBA Data[Home] [Help]

APPS.OTA_BSL_BUS dependencies on PER_BUSINESS_GROUPS

Line 201: from per_business_groups pbg

197: --
198: cursor csr_sec_grp is
199: select pbg.security_group_id,
200: pbg.legislation_code
201: from per_business_groups pbg
202: ,ota_booking_status_types bst
203: where bst.booking_status_type_id = p_booking_status_type_id
204: and pbg.business_group_id = bst.business_group_id ;
205: --

Line 273: from per_business_groups pbg

269: -- Declare cursor
270: --
271: cursor csr_leg_code is
272: select pbg.legislation_code
273: from per_business_groups pbg
274: , ota_booking_status_types_tl bstl
275: , ota_booking_status_types bst
276: where bstl.booking_status_type_id = p_booking_status_type_id
277: and bstl.language = p_language