APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on CS_TXN_BILLING_TYPES

Line 551: CS_TXN_BILLING_TYPES tbt,

547: edt.list_price , -- 4870210
548: i.item_type item_type_code --6523849
549: FROM CS_ESTIMATE_DETAILS edt,
550: CS_TXN_BILLING_OETXN_ALL tb,
551: CS_TXN_BILLING_TYPES tbt,
552: MTL_SYSTEM_ITEMS_KFV i,
553: CS_INCIDENTS_ALL_B sr,
554: CS_TRANSACTION_TYPES_B tt,
555: cs_billing_type_categories cbtc

Line 1510: FROM cs_txn_billing_types

1506: IF EstDtlTab(i).rollup_flag = 'Y' THEN
1507:
1508: /* SELECT billing_type
1509: INTO l_billing_flag
1510: FROM cs_txn_billing_types
1511: WHERE txn_billing_type_id = EstDtlTab(i).txn_billing_type_id; */
1512:
1513: /*
1514: SELECT cbtc.billing_category

Line 1516: FROM cs_txn_billing_types ctbt, cs_billing_type_categories cbtc

1512:
1513: /*
1514: SELECT cbtc.billing_category
1515: INTO l_billing_flag
1516: FROM cs_txn_billing_types ctbt, cs_billing_type_categories cbtc
1517: WHERE ctbt.txn_billing_type_id = EstDtlTab(i).txn_billing_type_id
1518: AND ctbt.billing_type = cbtc.billing_type;
1519:
1520: IF l_billing_flag = 'L' THEN

Line 1855: FROM CS_TXN_BILLING_TYPES a,

1851: l_non_src_change_owner,
1852: l_non_src_change_owner_to_code,
1853: l_update_ib_flag,
1854: l_src_return_reqd_flag -- Bug 4586140
1855: FROM CS_TXN_BILLING_TYPES a,
1856: csi_txn_sub_types b,
1857: csi_txn_types c
1858: WHERE a.txn_billing_type_id = EstDtlTab(i).txn_billing_type_id
1859: AND a.transaction_type_id = b.cs_transaction_type_id