DBA Data[Home] [Help]

APPS.CSD_MIGRATE_FROM_115X_PKG3 dependencies on STANDARD

Line 2632: --Cursor to get resource cost for a resource id. We only consider standard/frozen costing type.

2628: AND ESTD.estimate_detail_id = ESTL.estimate_detail_id
2629: AND TXNT.txn_billing_type_id = ESTD.txn_billing_type_id
2630: AND BCAT.billing_type = TXNT.billing_type;
2631:
2632: --Cursor to get resource cost for a resource id. We only consider standard/frozen costing type.
2633: CURSOR cur_getResCost(p_bom_resource_id NUMBER,
2634: p_organization_id NUMBER)
2635: IS
2636: SELECT CRC.resource_rate

Line 2640: AND CRC.cost_type_id = 1; -- standard/frozen cost

2636: SELECT CRC.resource_rate
2637: FROM cst_resource_costs CRC
2638: WHERE CRC.resource_id = p_bom_resource_id
2639: AND CRC.organization_id = p_organization_id
2640: AND CRC.cost_type_id = 1; -- standard/frozen cost
2641:
2642: --Cursor to get resource UOM code for the given resource id
2643: CURSOR cur_getResUOMCode (p_bom_resource_id NUMBER)
2644: IS