APPS.PA_CI_SECURITY_PKG dependencies on PA_PROJECTS_ALL

Line 321: pa_projects_all ppa

317: BEGIN
318: SELECT ci.project_id, ppa.org_id
319: INTO l_project_id, l_project_org_id
320: FROM pa_control_items ci,
321: pa_projects_all ppa
322: WHERE ppa.project_id=ci.project_id
323: AND ci.ci_id=p_ci_id;
324:
325: --Control item cannot be updated across OU

Line 378: pa_projects_all ppa

374: /*
375: SELECT ci.project_id, ppa.org_id
376: INTO l_project_id, l_project_org_id
377: FROM pa_control_items ci,
378: pa_projects_all ppa
379: WHERE ppa.project_id=ci.project_id
380: AND ci.ci_id=p_ci_id;
381: */
382:

Line 435: FROM pa_control_items ci, pa_projects_all ppa

431: l_project_org_id NUMBER;
432: BEGIN
433: SELECT ci.project_id, ppa.org_id
434: INTO l_project_id, l_project_org_id
435: FROM pa_control_items ci, pa_projects_all ppa
436: WHERE ci.project_id=ppa.project_id
437: AND ci.ci_id = p_ci_id;
438:
439: --Control item cannot be updated across OU

Line 544: FROM pa_control_items ci, pa_projects_all ppa

540: end if;-- if(p_calling_context <> 'AMG') then
541:
542: SELECT ci.project_id, ppa.org_id
543: INTO l_project_id, l_project_org_id
544: FROM pa_control_items ci, pa_projects_all ppa
545: WHERE ci.project_id=ppa.project_id
546: AND ci.ci_id = p_ci_id;
547:
548: --Control item cannot be updated across OU

Line 583: FROM pa_control_items ci, pa_projects_all ppa

579:
580: BEGIN
581: SELECT ci.project_id, ppa.org_id
582: INTO l_project_id, l_project_org_id
583: FROM pa_control_items ci, pa_projects_all ppa
584: WHERE ci.project_id=ppa.project_id
585: AND ci.ci_id = p_ci_id;
586:
587: --Control item cannot be updated across OU

Line 721: pa_projects_all ppa,

717: BEGIN
718: SELECT 1
719: INTO l_tmp
720: FROM pa_ci_type_usage citu,
721: pa_projects_all ppa,
722: pa_project_types_all ppt
723: WHERE ppa.project_id = p_project_id
724: AND ppt.project_type = ppa.project_type
725: AND citu.project_type_id = ppt.project_type_id