APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on CS_TXN_BILLING_TYPES

Line 584: CS_TXN_BILLING_TYPES tbt,

580: edt.project_id, --12.2.2 Service Projects Integration
581: edt.project_task_id --12.2.2 Service Projects Integration
582: FROM CS_ESTIMATE_DETAILS edt,
583: CS_TXN_BILLING_OETXN_ALL tb,
584: CS_TXN_BILLING_TYPES tbt,
585: MTL_SYSTEM_ITEMS_KFV i,
586: CS_INCIDENTS_ALL_B sr,
587: CS_TRANSACTION_TYPES_B tt,
588: cs_billing_type_categories cbtc

Line 1636: FROM cs_txn_billing_types

1632: IF EstDtlTab(i).rollup_flag = 'Y' THEN
1633:
1634: /* SELECT billing_type
1635: INTO l_billing_flag
1636: FROM cs_txn_billing_types
1637: WHERE txn_billing_type_id = EstDtlTab(i).txn_billing_type_id; */
1638:
1639: /*
1640: SELECT cbtc.billing_category

Line 1642: FROM cs_txn_billing_types ctbt, cs_billing_type_categories cbtc

1638:
1639: /*
1640: SELECT cbtc.billing_category
1641: INTO l_billing_flag
1642: FROM cs_txn_billing_types ctbt, cs_billing_type_categories cbtc
1643: WHERE ctbt.txn_billing_type_id = EstDtlTab(i).txn_billing_type_id
1644: AND ctbt.billing_type = cbtc.billing_type;
1645:
1646: IF l_billing_flag = 'L' THEN

Line 1999: FROM CS_TXN_BILLING_TYPES a,

1995: l_non_src_change_owner,
1996: l_non_src_change_owner_to_code,
1997: l_update_ib_flag,
1998: l_src_return_reqd_flag -- Bug 4586140
1999: FROM CS_TXN_BILLING_TYPES a,
2000: csi_txn_sub_types b,
2001: csi_txn_types c
2002: WHERE a.txn_billing_type_id = EstDtlTab(i).txn_billing_type_id
2003: AND a.transaction_type_id = b.cs_transaction_type_id