APPS.INV_COPY_ORGANIZATION_REPORT dependencies on CST_RESOURCE_COSTS

Line 960: Init_Vars('CST_RESOURCE_COSTS');

956: Init_Vars('BOM_RESOURCES');
957: g_entity_names := Get_Err_Bom_Resources;
958: Put_Report_Data;
959:
960: Init_Vars('CST_RESOURCE_COSTS');
961: g_entity_names := Get_Err_Cst_Res_Costs;
962: Put_Report_Data;
963:
964: Init_Vars('CST_RESOURCE_OVERHEAD');

Line 3657: FROM CST_RESOURCE_COSTS crc1

3653: , p_organization_id NUMBER
3654: )
3655: IS
3656: SELECT br1.RESOURCE_CODE, cct1.COST_TYPE
3657: FROM CST_RESOURCE_COSTS crc1
3658: , CST_COST_TYPES cct1
3659: , BOM_RESOURCES br1
3660: WHERE crc1.ORGANIZATION_ID = p_model_org_id
3661: AND br1.RESOURCE_ID = crc1.RESOURCE_ID

Line 3664: FROM CST_RESOURCE_COSTS crc2

3660: WHERE crc1.ORGANIZATION_ID = p_model_org_id
3661: AND br1.RESOURCE_ID = crc1.RESOURCE_ID
3662: AND cct1.COST_TYPE_ID = crc1.COST_TYPE_ID
3663: AND NOT EXISTS ( SELECT 'x'
3664: FROM CST_RESOURCE_COSTS crc2
3665: , CST_COST_TYPES cct2
3666: , BOM_RESOURCES br2
3667: WHERE crc2.ORGANIZATION_ID = p_organization_id
3668: AND br2.RESOURCE_ID = crc2.RESOURCE_ID

Line 3676: FROM CST_RESOURCE_COSTS crc

3672: );
3673: CURSOR l_cnt_csr ( p_org_id NUMBER )
3674: IS
3675: SELECT COUNT(crc.RESOURCE_ID)
3676: FROM CST_RESOURCE_COSTS crc
3677: WHERE crc.ORGANIZATION_ID = p_org_id;
3678:
3679: BEGIN
3680: