APPS.CSM_DEBRIEF_EVENT_PKG dependencies on CS_TXN_BILLING_TYPES

Line 25: function GET_DEBRIEF_PI_NAME (p_material_bill_type cs_txn_billing_types.billing_type%TYPE)

21: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTERS');
22: */
23:
24: /** Returns the name of the debrief Publication Item based upon the billing type **/
25: function GET_DEBRIEF_PI_NAME (p_material_bill_type cs_txn_billing_types.billing_type%TYPE)
26: return varchar2
27: is
28: l_debrief_pi_name varchar2(30);
29: l_no_billing_type_excp exception;

Line 58: cs_txn_billing_types txbt,

54: IS
55: SELECT cbtc.billing_category
56: FROM csf_debrief_lines lines,
57: mtl_system_items_b msi,
58: cs_txn_billing_types txbt,
59: CS_BILLING_TYPE_CATEGORIES cbtc
60: WHERE lines.debrief_line_id = p_debrief_line_id
61: AND msi.inventory_item_id = lines.inventory_item_id
62: AND msi.organization_id = NVL(NVL(lines.issuing_inventory_org_id, lines.receiving_inventory_org_id), csm_profile_pkg.get_organization_id(p_user_id))

Line 72: cs_txn_billing_types txbt,

68: CURSOR l_txn_billing_type_csr(p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE)
69: IS
70: SELECT cbtc.billing_category
71: FROM csf_debrief_lines lines,
72: cs_txn_billing_types txbt,
73: CS_BILLING_TYPE_CATEGORIES cbtc
74: WHERE lines.debrief_line_id = p_debrief_line_id
75: AND lines.txn_billing_type_id = txbt.txn_billing_type_id
76: AND txbt.billing_type = cbtc.billing_type;