APPS.JAI_INV_MMT_TRIGGER_PKG dependencies on MTL_TRANSACTION_TYPES

Line 226: FROM mtl_transaction_types

222:
223: CURSOR fetch_type_name(v_transaction_type_id IN NUMBER)
224: IS
225: SELECT transaction_type_name
226: FROM mtl_transaction_types
227: WHERE transaction_source_type_id = v_transaction_type_id;
228:
229: -- cbabu 25/07/02 for Bug#2480524, start
230: v_misc_recpt_rg_update NUMBER;

Line 235: FROM mtl_transaction_types

231: v_misc_issue_rg_update NUMBER;
232: CURSOR c_txn_type_id(v_transaction_type_name IN VARCHAR2)
233: IS
234: SELECT transaction_type_id
235: FROM mtl_transaction_types
236: WHERE transaction_type_name = v_transaction_type_name;
237: -- cbabu 25/07/02 for Bug#2480524, end
238:
239: /* Start, PROJECTS COSTING IMPL Bug#6012567(5765161)*/

Line 243: FROM mtl_transaction_types

239: /* Start, PROJECTS COSTING IMPL Bug#6012567(5765161)*/
240: CURSOR c_projects_flag(cp_transaction_type_id IN number)
241: IS
242: SELECT nvl(type_class,-1) projects_flag
243: FROM mtl_transaction_types
244: WHERE transaction_type_id = cp_transaction_type_id;
245:
246: ln_projects_flag mtl_transaction_types.type_class%type; /* PROJECTS COSTING IMPL */
247: /* End, PROJECTS COSTING IMPL Bug#6012567 (5765161)*/

Line 246: ln_projects_flag mtl_transaction_types.type_class%type; /* PROJECTS COSTING IMPL */

242: SELECT nvl(type_class,-1) projects_flag
243: FROM mtl_transaction_types
244: WHERE transaction_type_id = cp_transaction_type_id;
245:
246: ln_projects_flag mtl_transaction_types.type_class%type; /* PROJECTS COSTING IMPL */
247: /* End, PROJECTS COSTING IMPL Bug#6012567 (5765161)*/
248:
249: CURSOR get_pr_uom_cur (v_item_id IN NUMBER, v_org_id IN NUMBER)
250: IS