APPS.CSM_TXN_BILL_TYPES_EVENT_PKG dependencies on CS_TRANSACTION_TYPES_TL

Line 27: l_language cs_transaction_types_tl.language%TYPE;

23: l_pub_item varchar2(30) := 'CSF_M_TXN_BILLING_TYPES';
24: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
25: l_mark_dirty boolean;
26: l_access_id CSM_BUS_PROCESS_TXNS_ACC.ACCESS_ID%TYPE;
27: l_language cs_transaction_types_tl.language%TYPE;
28: l_business_process_id CS_BUS_PROCESS_TXNS.BUSINESS_PROCESS_ID%TYPE;
29: l_txn_billing_type_id cs_txn_billing_types.txn_billing_type_id%TYPE;
30: l_transaction_type_id cs_txn_billing_types.transaction_type_id%TYPE;
31: l_tl_omfs_palm_resource_list asg_download.user_list;

Line 78: FROM cs_transaction_types_tl tt_tl

74:
75: CURSOR l_txn_types_tl_cur (p_transaction_type_id IN cs_transaction_types_b.transaction_type_id%TYPE)
76: IS
77: SELECT tt_tl.LANGUAGE
78: FROM cs_transaction_types_tl tt_tl
79: WHERE tt_tl.transaction_type_id = p_transaction_type_id;
80:
81: cursor record_exists_csr( p_txn_billing_type_id csm_txn_billing_types_acc.txn_billing_type_id%TYPE,
82: p_business_process_id csm_txn_billing_types_acc.business_process_id%TYPE)

Line 133: cs_transaction_types_tl tt_tl,

129: l_dsql := 'select acc.access_id, tt_tl.language
130: from csm_txn_billing_types_acc acc,
131: cs_txn_billing_types tbt,
132: cs_transaction_types_b ttb,
133: cs_transaction_types_tl tt_tl,
134: cs_business_processes bpr,
135: cs_bus_process_txns bpt,
136: CS_BILLING_TYPE_CATEGORIES cbtc
137: where acc.txn_billing_type_id = tbt.txn_billing_type_id