DBA Data[Home] [Help]

APPS.OTA_TCC_BUS dependencies on OTA_CROSS_CHARGES

Line 29: , ota_cross_charges tcc

25: --
26: cursor csr_sec_grp is
27: select pbg.security_group_id
28: from per_business_groups pbg
29: , ota_cross_charges tcc
30: where tcc.cross_charge_id = p_cross_charge_id
31: and pbg.business_group_id = tcc.business_group_id;
32: --
33: -- Declare local variables

Line 89: , ota_cross_charges tcc

85: --
86: cursor csr_leg_code is
87: select pbg.legislation_code
88: from per_business_groups pbg
89: , ota_cross_charges tcc
90: where tcc.cross_charge_id = p_cross_charge_id
91: and pbg.business_group_id = tcc.business_group_id;
92: --
93: -- Declare local variables

Line 228: FROM OTA_CROSS_CHARGES

224: l_exists varchar2(1);
225:
226: CURSOR TCC IS
227: SELECT null
228: FROM OTA_CROSS_CHARGES
229: WHERE cross_charge_id <> nvl(p_cross_charge_id,0) and
230: Business_group_id = p_business_group_id and
231: gl_Set_of_books_id = p_gl_set_of_books_id and
232: From_to = p_from_to and