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.1.12010000.2 2008/08/07 05:42:01 trajasek 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.1.12010000.2 2008/08/07 05:42:01 trajasek 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 259: csm_debrief_lines_acc acc

255: IS
256: SELECT acc.user_id, dbl.inventory_item_id, dbl.instance_id,
257: NVL(NVL(dbl.issuing_inventory_org_id, dbl.receiving_inventory_org_id), csm_profile_pkg.get_organization_id(p_user_id)) AS organization_id
258: FROM csf_debrief_lines dbl,
259: csm_debrief_lines_acc acc
260: WHERE dbl.debrief_line_id = p_debrief_line_id
261: AND acc.debrief_line_id = dbl.debrief_line_id
262: AND acc.user_id = p_user_id;
263:

Line 369: csm_debrief_lines_acc acc,

365: NVL(nvl(issuing_inventory_org_id, receiving_inventory_org_id), csm_profile_pkg.get_organization_id(jtrs.user_id)) AS organization_id,
366: acc.access_id
367: FROM csf_debrief_lines dbl,
368: csf_debrief_headers dhdr,
369: csm_debrief_lines_acc acc,
370: jtf_task_assignments jta,
371: jtf_rs_resource_extns jtrs
372: WHERE dbl.debrief_line_id = p_debrief_line_id
373: AND dbl.debrief_header_id = dhdr.debrief_header_id