APPS.FUN_OPEN_INTERFACE_PKG dependencies on FUN_TRX_TYPES_VL

Line 79: FROM fun_Trx_types_vl

75: AND ledger_category_code = 'PRIMARY';
76:
77: Cursor c_trx_type_id_per_name(l_trx_type_name IN VARCHAR2) IS
78: SELECT trx_type_id
79: FROM fun_Trx_types_vl
80: WHERE trx_type_name = l_Trx_type_name;
81:
82: Cursor c_trx_type_id_per_code(l_trx_type_code IN VARCHAR2) IS
83: SELECT trx_type_id

Line 84: FROM fun_Trx_types_vl

80: WHERE trx_type_name = l_Trx_type_name;
81:
82: Cursor c_trx_type_id_per_code(l_trx_type_code IN VARCHAR2) IS
83: SELECT trx_type_id
84: FROM fun_Trx_types_vl
85: WHERE trx_type_code = l_Trx_type_code;
86:
87: Cursor c_trx_type_code_per_id(l_trx_type_id IN VARCHAR2) IS
88: SELECT trx_type_code

Line 89: FROM fun_Trx_types_vl

85: WHERE trx_type_code = l_Trx_type_code;
86:
87: Cursor c_trx_type_code_per_id(l_trx_type_id IN VARCHAR2) IS
88: SELECT trx_type_code
89: FROM fun_Trx_types_vl
90: WHERE trx_type_id = l_Trx_type_id;
91:
92: Cursor c_from_le_id (l_party_id IN NUMBER) IS --3603338 new cursor
93: SELECT legal_entity_id

Line 464: from fun_trx_types_vl

460: Where batch_id = l_batch_id;
461:
462: Cursor c_inv_flag(c_trx_type_id IN NUMBER ) IS
463: Select allow_invoicing_flag
464: from fun_trx_types_vl
465: where trx_type_id = c_trx_type_id;
466:
467: Curr_batch fun_interface_batches%rowtype;
468: Curr_head fun_interface_headers%rowtype;