APPS.PA_FUND_REVAL_PVT dependencies on PA_PROJECTS

Line 734: FROM pa_projects p, pa_project_types pt

730: IF p_run_mode = 'SINGLE' THEN
731:
732: SELECT p.segment1, pt.project_type_id
733: INTO l_FromProjNum, l_ProjTypeId
734: FROM pa_projects p, pa_project_types pt
735: WHERE p.project_id = p_project_id
736: AND pt.project_type = p.project_type;
737:
738: l_ToProjNum := l_FromProjNum;

Line 748: FROM PA_PROJECTS P , PA_PROJECT_TYPES T

744:
745: /*
746: SELECT MIN(P.segment1)
747: INTO l_FromProjNum
748: FROM PA_PROJECTS P , PA_PROJECT_TYPES T
749: WHERE T.project_type_id (+) = l_ProjTypeId
750: AND P.Project_type = T.Project_type
751: AND T.Project_type_class_code = 'CONTRACT';
752: */

Line 759: FROM PA_PROJECTS P , PA_PROJECT_TYPES T

755: SELECT proj.seg1
756: INTO l_FromProjNum
757: FROM (
758: SELECT t.project_type_class_code, MIN(P.segment1) seg1
759: FROM PA_PROJECTS P , PA_PROJECT_TYPES T
760: WHERE T.project_type_id = NVL(l_ProjTypeId,0)
761: AND P.Project_type = T.Project_type
762: AND T.Project_type_class_code = 'CONTRACT'
763: AND NVL(l_ProjTypeId,0) <> 0

Line 767: FROM PA_PROJECTS P , PA_PROJECT_TYPES T

763: AND NVL(l_ProjTypeId,0) <> 0
764: GROUP BY t.project_type_class_code
765: UNION
766: SELECT t.project_type_class_code, MIN(P.segment1) seg1
767: FROM PA_PROJECTS P , PA_PROJECT_TYPES T
768: WHERE P.Project_type = T.Project_type
769: AND T.Project_type_class_code = 'CONTRACT'
770: AND nvl(l_ProjTypeId,0) = 0
771: group by t.project_type_class_code

Line 788: FROM PA_PROJECTS P , PA_PROJECT_TYPES T

784:
785: /*
786: SELECT MAX(P.segment1)
787: INTO l_ToProjNum
788: FROM PA_PROJECTS P , PA_PROJECT_TYPES T
789: WHERE T.project_type_id (+) = l_ProjTypeId
790: AND P.Project_type = T.Project_type
791: AND T.Project_type_class_code = 'CONTRACT';
792: */

Line 799: FROM PA_PROJECTS P , PA_PROJECT_TYPES T

795: SELECT proj.seg1
796: INTO l_ToProjNum
797: FROM (
798: SELECT t.project_type_class_code, MAX(P.segment1) seg1
799: FROM PA_PROJECTS P , PA_PROJECT_TYPES T
800: WHERE T.project_type_id = NVL(l_ProjTypeId,0)
801: AND P.Project_type = T.Project_type
802: AND T.Project_type_class_code = 'CONTRACT'
803: AND NVL(l_ProjTypeId,0) <> 0

Line 807: FROM PA_PROJECTS P , PA_PROJECT_TYPES T

803: AND NVL(l_ProjTypeId,0) <> 0
804: GROUP BY t.project_type_class_code
805: UNION
806: SELECT t.project_type_class_code, MAX(P.segment1) seg1
807: FROM PA_PROJECTS P , PA_PROJECT_TYPES T
808: WHERE P.Project_type = T.Project_type
809: AND T.Project_type_class_code = 'CONTRACT'
810: AND nvl(l_ProjTypeId,0) = 0
811: group by t.project_type_class_code

Line 1436: FROM pa_projects P, pa_project_types T

1432: 'PROJFUNC_CURRENCY', P.projfunc_bil_exchange_rate,
1433: 'FUNDING_CURRENCY', P.funding_exchange_rate) invproc_exchange_rate,
1434: T.RLZD_GAINS_EVENT_TYPE_ID,
1435: T.RLZD_LOSSES_EVENT_TYPE_ID
1436: FROM pa_projects P, pa_project_types T
1437: WHERE P.segment1 BETWEEN p_from_proj_number
1438: AND p_to_proj_number
1439: AND P.PROJECT_TYPE = T.PROJECT_TYPE
1440: AND T.DIRECT_FLAG = 'Y'

Line 10194: FROM pa_projects P, pa_project_types T

10190:
10191: CURSOR open_projects IS
10192: SELECT P.segment1, P.project_id, P.baseline_funding_flag,
10193: P.include_gains_losses_flag include_gains_losses_flag
10194: FROM pa_projects P, pa_project_types T
10195: WHERE P.segment1 BETWEEN p_from_proj_number
10196: AND p_to_proj_number
10197: AND P.PROJECT_TYPE = T.PROJECT_TYPE
10198: AND T.DIRECT_FLAG = 'Y'