APPS.FPA_PROJECT_PVT dependencies on PA_CLASS_CODES

Line 65: PA_CLASS_CODES PCC,

61: PA.CARRYING_OUT_ORGANIZATION_ID
62: FROM
63: PA_PROJECT_CLASSES PAC,
64: PA_PROJECTS_ALL PA,
65: PA_CLASS_CODES PCC,
66: FPA_AW_PORTF_HEADERS_V PTF
67: WHERE
68: PTF.PORTFOLIO_CLASS_CODE = PCC.CLASS_CODE_ID
69: AND PAC.CLASS_CODE = PCC.CLASS_CODE

Line 102: PA_PROJECT_CLASSES PAC, PA_CLASS_CODES CC

98: PC.PLANNING_CYCLE,
99: CC.CLASS_CODE_ID
100: FROM
101: FPA_AW_PC_INFO_V PC, PA_CLASS_CATEGORIES PCC,
102: PA_PROJECT_CLASSES PAC, PA_CLASS_CODES CC
103: WHERE
104: PC.PC_STATUS IN ('COLLECTING', 'ANALYSIS')
105: AND PC.PC_CATEGORY = PCC.CLASS_CATEGORY_ID
106: AND PAC.CLASS_CATEGORY = PCC.CLASS_CATEGORY

Line 115: l_class_code PA_CLASS_CODES.CLASS_CODE%TYPE := null;

111:
112:
113: l_portfolio_id FPA_AW_PORTF_HEADERS_V.PORTFOLIO%TYPE := null;
114: l_portfolio_org_id FPA_AW_PORTF_HEADERS_V.PORTFOLIO_ORGANIZATION%TYPE := null;
115: l_class_code PA_CLASS_CODES.CLASS_CODE%TYPE := null;
116: l_class_code_id PA_CLASS_CODES.CLASS_CODE_ID%TYPE := null;
117: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;
118: l_project_org_id HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE := null;
119: l_pjp_org_version_id PER_ORG_STRUCTURE_VERSIONS.ORG_STRUCTURE_VERSION_ID%TYPE := null;

Line 116: l_class_code_id PA_CLASS_CODES.CLASS_CODE_ID%TYPE := null;

112:
113: l_portfolio_id FPA_AW_PORTF_HEADERS_V.PORTFOLIO%TYPE := null;
114: l_portfolio_org_id FPA_AW_PORTF_HEADERS_V.PORTFOLIO_ORGANIZATION%TYPE := null;
115: l_class_code PA_CLASS_CODES.CLASS_CODE%TYPE := null;
116: l_class_code_id PA_CLASS_CODES.CLASS_CODE_ID%TYPE := null;
117: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;
118: l_project_org_id HR_ALL_ORGANIZATION_UNITS.ORGANIZATION_ID%TYPE := null;
119: l_pjp_org_version_id PER_ORG_STRUCTURE_VERSIONS.ORG_STRUCTURE_VERSION_ID%TYPE := null;
120: l_flag VARCHAR2(1) := null;