[Home] [Help]
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;
32: l_single_access_id_list asg_download.access_list;
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
58: where acc.txn_billing_type_id = tbt.txn_billing_type_id
59: AND acc.business_process_id = bpt.business_process_id
60: AND tbt.transaction_type_id = ttb.transaction_type_id
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
138: AND acc.business_process_id = bpt.business_process_id
139: AND tbt.transaction_type_id = ttb.transaction_type_id
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
198: where tbt.transaction_type_id = ttb.transaction_type_id
199: AND SYSDATE BETWEEN nvl(tbt.start_date_active, SYSDATE) AND nvl(tbt.end_date_active, SYSDATE)
200: AND SYSDATE BETWEEN nvl(ttb.start_date_active, SYSDATE) AND nvl(ttb.end_date_active, SYSDATE)