APPS.CSM_BUS_PROCESS_TXNS_EVENT_PKG dependencies on CS_BUSINESS_PROCESSES

Line 49: CS_BUSINESS_PROCESSES bpr

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
53: AND bpr.field_service_flag = 'Y');

Line 60: l_bpr_last_update_date CS_BUSINESS_PROCESSES.LAST_UPDATE_DATE%TYPE;

56: select csm_bus_processes_acc_s.nextval FROM dual;
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;

Line 113: CS_BUSINESS_PROCESSES bpr,

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
117: AND bpt.business_process_id = acc.business_process_id

Line 164: CS_BUSINESS_PROCESSES bpr

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
168: (SELECT access_id