DBA Data[Home] [Help]

APPS.PJM_COMMITMENT_UTILS dependencies on BOM_RESOURCES

Line 38: from bom_resources

34:
35: BEGIN
36:
37: select resource_code into L_Resource_Code
38: from bom_resources
39: where resource_id = X_resource_id;
40:
41: RETURN ( L_Resource_Code );
42:

Line 424: FROM bom_resources br

420: L_Exp_Type VARCHAR2(30);
421:
422: CURSOR c_org IS
423: SELECT br.expenditure_type
424: FROM bom_resources br
425: , cst_item_cost_details cicd
426: , mtl_parameters mp
427: WHERE mp.organization_id = X_Org_ID
428: AND cicd.organization_id (+) = mp.organization_id

Line 457: FROM bom_resources

453: ) RETURN VARCHAR2 IS
454:
455: CURSOR c_res IS
456: SELECT expenditure_type
457: FROM bom_resources
458: WHERE resource_id = X_Resource_ID;
459:
460: L_Exp_Type VARCHAR2(30);
461:

Line 493: FROM bom_resources

489: AND project_id = X_Project_ID;
490:
491: CURSOR c_res IS
492: SELECT expenditure_type
493: FROM bom_resources
494: WHERE resource_id = X_Resource_ID;
495:
496: L_Exp_Type VARCHAR2(30);
497: