APPS.CSM_DEBRIEF_EVENT_PKG dependencies on CSM_DEBRIEF_LINES_ACC

Line 4: g_debrief_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_LINES_ACC';

1: PACKAGE BODY CSM_DEBRIEF_EVENT_PKG AS
2: /* $Header: csmedebb.pls 120.2.12020000.2 2013/04/09 10:53:51 saradhak ship $ */
3:
4: g_debrief_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_LINES_ACC';
5: g_debrief_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_LINES';
6: g_debrief_seq_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_LINES_ACC_S';
7: g_debrief_pk1_name CONSTANT VARCHAR2(30) := 'DEBRIEF_LINE_ID';
8: g_debrief_pubi_name CSM_ACC_PKG.t_publication_item_list;

Line 6: g_debrief_seq_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_LINES_ACC_S';

2: /* $Header: csmedebb.pls 120.2.12020000.2 2013/04/09 10:53:51 saradhak ship $ */
3:
4: g_debrief_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_LINES_ACC';
5: g_debrief_table_name CONSTANT VARCHAR2(30) := 'CSF_DEBRIEF_LINES';
6: g_debrief_seq_name CONSTANT VARCHAR2(30) := 'CSM_DEBRIEF_LINES_ACC_S';
7: g_debrief_pk1_name CONSTANT VARCHAR2(30) := 'DEBRIEF_LINE_ID';
8: g_debrief_pubi_name CSM_ACC_PKG.t_publication_item_list;
9: g_labor_billing_type_category CONSTANT VARCHAR2(30) := 'L';
10:

Line 266: csm_debrief_lines_acc acc

262: SELECT acc.user_id, dbl.inventory_item_id, dbl.instance_id,
263: NVL(NVL(dbl.issuing_inventory_org_id, dbl.receiving_inventory_org_id), csm_profile_pkg.get_organization_id(p_user_id)) AS organization_id,
264: usage_type
265: FROM csf_debrief_lines dbl,
266: csm_debrief_lines_acc acc
267: WHERE dbl.debrief_line_id = p_debrief_line_id
268: AND acc.debrief_line_id = dbl.debrief_line_id
269: AND acc.user_id = p_user_id;
270:

Line 383: csm_debrief_lines_acc acc,

379: acc.access_id,
380: usage_type
381: FROM csf_debrief_lines dbl,
382: csf_debrief_headers dhdr,
383: csm_debrief_lines_acc acc,
384: jtf_task_assignments jta,
385: jtf_rs_resource_extns jtrs
386: WHERE dbl.debrief_line_id = p_debrief_line_id
387: AND dbl.debrief_header_id = dhdr.debrief_header_id