APPS.OTA_BJT_BUS dependencies on OTA_BKNG_JUSTIFICATIONS_B

Line 32: ,ota_bkng_justifications_b bjs

28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: ,ota_bkng_justifications_b bjs
33: where bjs.booking_justification_id = p_booking_justification_id
34: and pbg.business_group_id = bjs.business_group_id;
35: --
36: -- Declare local variables

Line 104: , ota_bkng_justifications_b bjs

100: --
101: cursor csr_leg_code is
102: select pbg.legislation_code
103: from per_business_groups_perf pbg
104: , ota_bkng_justifications_b bjs
105: where bjs.booking_justification_id = p_booking_justification_id
106: and pbg.business_group_id = bjs.business_group_id;
107: --
108: -- Declare local variables

Line 234: FROM ota_bkng_justifications_b

230: l_proc varchar2(72) := g_package ||'.check_name';
231:
232: CURSOR csr_get_bg IS
233: select business_group_id
234: FROM ota_bkng_justifications_b
235: WHERE booking_justification_id = p_booking_justification_id;
236:
237: CURSOR csr_get_name(p_business_group_id NUMBER) IS
238: SELECT 1

Line 240: ota_bkng_justifications_b bjs

236:
237: CURSOR csr_get_name(p_business_group_id NUMBER) IS
238: SELECT 1
239: FROM ota_bkng_justifications_tl bjt,
240: ota_bkng_justifications_b bjs
241: WHERE bjs.booking_justification_id = bjt.booking_justification_id
242: AND bjs.business_group_id = p_business_group_id
243: AND bjt.justification_text = p_justification_text
244: AND bjt.language = USERENV('LANG')

Line 286: ,p_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE

282: -- |---------------------------< insert_validate >----------------------------|
283: -- ----------------------------------------------------------------------------
284: Procedure insert_validate
285: (p_rec in ota_bjt_shd.g_rec_type
286: ,p_booking_justification_id ota_bkng_justifications_b.booking_justification_id%TYPE
287: ) is
288: --
289: l_proc varchar2(72) := g_package||'insert_validate';
290: --