APPS.CSM_CSP_REQ_LINES_EVENT_PKG dependencies on CSM_REQ_LINES_ACC_S

Line 17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC_S';

13: -- Enter procedure, function bodies as shown below
14:
15: g_table_name1 CONSTANT VARCHAR2(30) := 'CSP_REQUIREMENT_LINES';
16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC';
17: g_acc_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC_S';
18: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
19: CSM_ACC_PKG.t_publication_item_list('CSM_REQ_LINES');
20: g_pk1_name1 CONSTANT VARCHAR2(30) := 'REQUIREMENT_LINE_ID';
21:

Line 342: select CSM_REQ_LINES_ACC_S.nextval,req_line_detail_id,user_id,b.inventory_item_id,d.destination_organization_id,b.source_id,sysdate,sysdate,1,1

338: CLOSE c_get_dtl;
339:
340: IF (l_tab_access_id.COUNT=0) AND p_dml_t <> 'D' THEN
341: INSERT INTO CSM_REQ_LINE_DETAILS_ACC(ACCESS_ID,REQ_LINE_DETAIL_ID,USER_ID,ITEM_ID,ORG_ID,SOURCE_ID,CREATION_DATE,LAST_UPDATE_DATE,CREATED_BY,LAST_UPDATED_BY)
342: select CSM_REQ_LINES_ACC_S.nextval,req_line_detail_id,user_id,b.inventory_item_id,d.destination_organization_id,b.source_id,sysdate,sysdate,1,1
343: from (select b.req_line_detail_id,a.user_id,c.inventory_item_id,b.requirement_line_id,b.source_id
344: from csm_req_lines_acc a, csp_req_line_details b ,
345: oe_order_lines_all c ,asg_user au
346: where a.requirement_line_id=b.requirement_line_id