APPS.PA_PAXFRADR_XMLP_PKG dependencies on PA_PROJECTS

Line 32: PA_PROJECTS_ALL

28: SELECT
29: SEGMENT1
30: INTO P_FROM_PROJECT_NUMBER
31: FROM
32: PA_PROJECTS_ALL
33: WHERE PROJECT_ID = P_FROM_PROJECT_NUMBER;
34: END;
35: END IF;
36: IF P_TO_PROJECT_NUMBER IS NOT NULL THEN

Line 42: PA_PROJECTS_ALL

38: SELECT
39: SEGMENT1
40: INTO P_TO_PROJECT_NUMBER
41: FROM
42: PA_PROJECTS_ALL
43: WHERE PROJECT_ID = P_TO_PROJECT_NUMBER;
44: END;
45: END IF;
46: IF P_PROJ_TYPE IS NOT NULL THEN

Line 68: PA_PROJECTS P

64: DISTINCT
65: 'N'
66: INTO L_EXIST_FLAG
67: FROM
68: PA_PROJECTS P
69: WHERE P.SEGMENT1 BETWEEN NVL(P_FROM_PROJECT_NUMBER
70: ,'0')
71: AND NVL(P_TO_PROJECT_NUMBER
72: ,'z')

Line 97: PA_PROJECTS P

93: DISTINCT
94: 'Y'
95: INTO L_EXIST_FLAG
96: FROM
97: PA_PROJECTS P
98: WHERE P.SEGMENT1 BETWEEN NVL(P_FROM_PROJECT_NUMBER
99: ,'0')
100: AND NVL(P_TO_PROJECT_NUMBER
101: ,'z')