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 418: FROM bom_resources br

414: L_Exp_Type VARCHAR2(30);
415:
416: CURSOR c_org IS
417: SELECT br.expenditure_type
418: FROM bom_resources br
419: , cst_item_cost_details cicd
420: , mtl_parameters mp
421: WHERE mp.organization_id = X_Org_ID
422: AND cicd.organization_id (+) = mp.organization_id

Line 451: FROM bom_resources

447: ) RETURN VARCHAR2 IS
448:
449: CURSOR c_res IS
450: SELECT expenditure_type
451: FROM bom_resources
452: WHERE resource_id = X_Resource_ID;
453:
454: L_Exp_Type VARCHAR2(30);
455:

Line 486: FROM bom_resources

482: AND project_id = X_Project_ID;
483:
484: CURSOR c_res IS
485: SELECT expenditure_type
486: FROM bom_resources
487: WHERE resource_id = X_Resource_ID;
488:
489: L_Exp_Type VARCHAR2(30);
490: