APPS.OKL_REVERSE_CONTRACT_PVT dependencies on OKL_TRX_TYPES_B

Line 109: FROM OKL_TRX_CONTRACTS TC, OKL_TRX_TYPES_B TTB

105: IS
106:
107: CURSOR trx_type_cur IS
108: SELECT '1'
109: FROM OKL_TRX_CONTRACTS TC, OKL_TRX_TYPES_B TTB
110: WHERE TC.KHR_ID = p_contract_id
111: AND TC.TRY_ID = TTB.ID
112: --rkuttiya added for 12.1.1 Multi GAAP
113: AND TC.REPRESENTATION_TYPE = 'PRIMARY'

Line 120: FROM OKL_TRX_ASSETS A, OKL_TXL_ASSETS_B B, OKL_TRX_TYPES_B TTB

116: G_UPFRONT_TAX); -- G_UPFRONT_TAX introduced for R12 ebTax requirement
117:
118: CURSOR asset_cur IS
119: SELECT '1'
120: FROM OKL_TRX_ASSETS A, OKL_TXL_ASSETS_B B, OKL_TRX_TYPES_B TTB
121: WHERE B.DNZ_KHR_ID = p_contract_id
122: AND A.ID = B.TAS_ID
123: AND A.TRY_ID = TTB.ID
124: AND TTB.TRX_TYPE_CLASS NOT IN (G_INTERNAL_ASSET_CREATION);

Line 130: FROM OKL_TRX_AP_INVOICES_B TAI, OKL_TRX_TYPES_B TTB

126: -- sjalasut, modified the cursor to refer khr_id from okl_txl_ap_inv_lns_all_b instead
127: -- of okl_trx_ap_invoices_b. changes made as part of OKLR12B disbursements project
128: CURSOR ap_inv_cur IS
129: SELECT '1'
130: FROM OKL_TRX_AP_INVOICES_B TAI, OKL_TRX_TYPES_B TTB
131: ,OKL_TXL_AP_INV_LNS_ALL_B TPL
132: WHERE TAI.ID = TPL.TAP_ID
133: AND TPL.KHR_ID = p_contract_id
134: AND TAI.TRY_ID = TTB.ID

Line 288: FROM OKL_TRX_TYPES_B

284: WHERE TAP_ID = p_tap_id;
285:
286: CURSOR trx_type_cur (p_try_id NUMBER) IS
287: SELECT TRX_TYPE_CLASS
288: FROM OKL_TRX_TYPES_B
289: WHERE ID = p_try_id;
290:
291: CURSOR dist_cur (p_source_table VARCHAR2, p_source_id NUMBER) IS
292: SELECT '1'

Line 689: FROM OKL_TRX_TYPES_B TRYB,

685: -- Bug 5202448 : kbbhavsa : 12-May-2006 : Start
686: -- Changed the cursor definition for language support
687: CURSOR l_tryv_csr IS
688: SELECT TRYB.id
689: FROM OKL_TRX_TYPES_B TRYB,
690: OKL_TRX_TYPES_TL TRYT
691: WHERE
692: TRYB.ID = TRYT.ID and
693: TRYT.LANGUAGE = 'US' and