APPS.CSM_DEBRIEF_EVENT_PKG dependencies on CS_BILLING_TYPE_CATEGORIES

Line 50: l_billing_type_category cs_billing_type_categories.billing_category%TYPE;

46: l_sqlerrno VARCHAR2(20);
47: l_sqlerrmsg VARCHAR2(4000);
48: l_error_msg VARCHAR2(4000);
49: l_return_status VARCHAR2(2000);
50: l_billing_type_category cs_billing_type_categories.billing_category%TYPE;
51:
52: --getting billing category using transaction type id
53: CURSOR l_txn_billing_csr(p_debrief_line_id csf_debrief_lines.debrief_line_id%TYPE, p_user_id IN NUMBER)
54: IS

Line 59: CS_BILLING_TYPE_CATEGORIES cbtc

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))
63: AND lines.transaction_type_id = txbt.transaction_type_id

Line 73: CS_BILLING_TYPE_CATEGORIES cbtc

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;
77: