APPS.CSM_BUS_PROCESS_TXNS_EVENT_PKG dependencies on CS_BUS_PROCESS_TXNS

Line 48: FROM CS_BUS_PROCESS_TXNS bpt,

44: SELECT acc.access_id
45: FROM CSM_BUS_PROCESS_TXNS_ACC acc
46: WHERE NOT EXISTS
47: (SELECT bpt.BUSINESS_PROCESS_ID
48: FROM CS_BUS_PROCESS_TXNS bpt,
49: CS_BUSINESS_PROCESSES bpr
50: WHERE bpt.transaction_type_id = acc.transaction_type_id
51: AND bpt.business_process_id = acc.business_process_id
52: AND bpr.business_process_id = bpt.business_process_id

Line 61: l_bpt_last_update_date CS_BUS_PROCESS_TXNS.LAST_UPDATE_DATE%TYPE;

57:
58:
59: l_mark_dirty boolean;
60: l_bpr_last_update_date CS_BUSINESS_PROCESSES.LAST_UPDATE_DATE%TYPE;
61: l_bpt_last_update_date CS_BUS_PROCESS_TXNS.LAST_UPDATE_DATE%TYPE;
62: l_max_update_date CSM_BUS_PROCESS_TXNS_ACC.LAST_UPDATE_DATE%TYPE;
63:
64: l_access_id CSM_BUS_PROCESS_TXNS_ACC.ACCESS_ID%TYPE;
65: l_business_process_id CS_BUS_PROCESS_TXNS.BUSINESS_PROCESS_ID%TYPE;

Line 65: l_business_process_id CS_BUS_PROCESS_TXNS.BUSINESS_PROCESS_ID%TYPE;

61: l_bpt_last_update_date CS_BUS_PROCESS_TXNS.LAST_UPDATE_DATE%TYPE;
62: l_max_update_date CSM_BUS_PROCESS_TXNS_ACC.LAST_UPDATE_DATE%TYPE;
63:
64: l_access_id CSM_BUS_PROCESS_TXNS_ACC.ACCESS_ID%TYPE;
65: l_business_process_id CS_BUS_PROCESS_TXNS.BUSINESS_PROCESS_ID%TYPE;
66: l_transaction_type_id CS_BUS_PROCESS_TXNS.TRANSACTION_TYPE_ID%TYPE;
67: l_run_date DATE;
68:
69: BEGIN

Line 66: l_transaction_type_id CS_BUS_PROCESS_TXNS.TRANSACTION_TYPE_ID%TYPE;

62: l_max_update_date CSM_BUS_PROCESS_TXNS_ACC.LAST_UPDATE_DATE%TYPE;
63:
64: l_access_id CSM_BUS_PROCESS_TXNS_ACC.ACCESS_ID%TYPE;
65: l_business_process_id CS_BUS_PROCESS_TXNS.BUSINESS_PROCESS_ID%TYPE;
66: l_transaction_type_id CS_BUS_PROCESS_TXNS.TRANSACTION_TYPE_ID%TYPE;
67: l_run_date DATE;
68:
69: BEGIN
70: -- get last conc program update date

Line 112: FROM CS_BUS_PROCESS_TXNS bpt,

108: /******* UPDATES **********/
109: --generate sql for updates
110: l_dsql :=
111: 'SELECT acc.access_id, bpt.last_update_date, bpr.last_update_date
112: FROM CS_BUS_PROCESS_TXNS bpt,
113: CS_BUSINESS_PROCESSES bpr,
114: CSM_BUS_PROCESS_TXNS_ACC acc
115: WHERE bpr.business_process_id = bpt.business_process_id
116: AND bpt.transaction_type_id = acc.transaction_type_id

Line 163: FROM CS_BUS_PROCESS_TXNS bpt,

159: /****** INSERTS **********/
160: --generate sql for inserts
161: l_dsql :=
162: 'SELECT bpt.business_process_id, bpt.transaction_type_id, bpt.last_update_date, bpr.last_update_date
163: FROM CS_BUS_PROCESS_TXNS bpt,
164: CS_BUSINESS_PROCESSES bpr
165: WHERE bpr.business_process_id = bpt.business_process_id
166: AND bpr.field_service_flag = ''Y''
167: AND NOT EXISTS