APPS.INV_PROJECT dependencies on MTL_PARAMETERS

Line 263: FROM mtl_parameters mp

259: NVL(mp.project_control_level,1)
260: INTO p_project_reference_enabled,
261: p_pm_cost_collection_enabled,
262: p_project_control_level
263: FROM mtl_parameters mp
264: WHERE organization_id = org_id ;
265:
266: EXCEPTION
267: WHEN OTHERS then

Line 454: FROM mtl_parameters

450: end if;
451:
452: SELECT NVL(project_reference_enabled,2), NVL(project_control_level,1)
453: INTO prj_ref_enabled, prj_cntrl_level
454: FROM mtl_parameters
455: WHERE organization_id = fm_org_id ;
456: /* We are going to get task ids no matter what the control level is
457: But are keeping reference for control level in case later we decide to
458: filter on this. So now, setting cntrl_level = 2 (task level)

Line 524: FROM mtl_parameters

520: end if;
521:
522: SELECT NVL(project_reference_enabled,2), NVL(project_control_level,1)
523: INTO to_org_prj_ref_enabled, to_org_prj_cntrl_level
524: FROM mtl_parameters
525: WHERE organization_id = to_org_id ;
526:
527: /* We are going to get task ids no matter what the control level is
528: But are keeping reference for control level in case later we decide to

Line 690: FROM mtl_parameters

686: end if;
687:
688: SELECT NVL(project_control_level,1)
689: INTO x_fm_org_project_control_level
690: FROM mtl_parameters
691: WHERE organization_id = v_org_id ;
692:
693: if ( v_txn_action_id = 3 ) then
694: SELECT NVL(project_control_level,1)

Line 696: FROM mtl_parameters

692:
693: if ( v_txn_action_id = 3 ) then
694: SELECT NVL(project_control_level,1)
695: INTO x_to_org_project_control_level
696: FROM mtl_parameters
697: WHERE organization_id = v_xfr_org_id ;
698: end if;
699:
700: /*

Line 1182: FROM mtl_parameters

1178: BEGIN
1179: success := 'TRUE';
1180: SELECT NVL(project_reference_enabled,2)
1181: INTO l_project_reference_enabled
1182: FROM mtl_parameters
1183: WHERE organization_id = p_org_id ;
1184:
1185: IF l_project_reference_enabled <> 1 THEN
1186: success := 'FALSE';