APPS.CSM_TXN_BILL_TYPES_EVENT_PKG dependencies on CS_TXN_BILLING_TYPES

Line 29: l_txn_billing_type_id cs_txn_billing_types.txn_billing_type_id%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;
32: l_single_access_id_list asg_download.access_list;
33: --a null list

Line 30: l_transaction_type_id cs_txn_billing_types.transaction_type_id%TYPE;

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;
32: l_single_access_id_list asg_download.access_list;
33: --a null list
34: l_null_access_list asg_download.access_list;

Line 53: from cs_txn_billing_types tbt,

49: SELECT acc.access_id
50: FROM CSM_TXN_BILLING_TYPES_ACC acc
51: WHERE NOT EXISTS
52: (select tbt.TXN_BILLING_TYPE_ID
53: from cs_txn_billing_types tbt,
54: cs_transaction_types_b ttb,
55: cs_business_processes bpr,
56: cs_bus_process_txns bpt,
57: CS_BILLING_TYPE_CATEGORIES cbtc

Line 131: cs_txn_billing_types tbt,

127: /******* UPDATES **********/
128: --generate sql for updates
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,

Line 193: from cs_txn_billing_types tbt,

189:
190: /****** INSERTS **********/
191: --generate sql for inserts
192: l_dsql := 'select tbt.TXN_BILLING_TYPE_ID, bpt.business_process_id, tbt.transaction_type_id
193: from cs_txn_billing_types tbt,
194: cs_transaction_types_b ttb,
195: cs_business_processes bpr,
196: cs_bus_process_txns bpt,
197: CS_BILLING_TYPE_CATEGORIES cbtc