DBA Data[Home] [Help]

APPS.FPA_PROJECT_PVT dependencies on PA_PROJECT_CLASSES

Line 63: PA_PROJECT_CLASSES PAC,

59: PAC.CLASS_CODE,
60: PTF.PORTFOLIO_ORGANIZATION,
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

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