APPS.CSM_CSP_REQ_LINES_EVENT_PKG dependencies on CSM_REQ_LINES_ACC

Line 16: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_REQ_LINES_ACC';

12: -- --------- ------ ------------------------------------------
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';

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 145: FROM csm_req_lines_acc acc

141: CURSOR c_order_info (b_last_run_date DATE)
142: IS
143: SELECT acc.user_id
144: , acc.access_id
145: FROM csm_req_lines_acc acc
146: , CSP_REQ_LINE_DETAILS crld
147: , OE_ORDER_LINES_ALL ol
148: WHERE acc.requirement_line_id = crld.requirement_line_id
149: AND crld.source_id = ol.line_id