DBA Data[Home] [Help]

APPS.FPA_VALIDATION_PROCESS_PVT dependencies on FPA_AW_PC_INFO_V

Line 31: FROM FPA_AW_PC_INFO_V PC, GL_PERIODS GLS, GL_PERIODS GLE

27:
28: CURSOR FUNDING_DATES_CSR (PC_ID IN NUMBER) IS
29: SELECT GLS.START_DATE,
30: GLE.END_DATE
31: FROM FPA_AW_PC_INFO_V PC, GL_PERIODS GLS, GL_PERIODS GLE
32: WHERE PC.CALENDAR_NAME = GLS.PERIOD_SET_NAME
33: AND PC.PERIOD_TYPE = GLS.PERIOD_TYPE
34: AND PC.CALENDAR_NAME = GLE.PERIOD_SET_NAME
35: AND PC.PERIOD_TYPE = GLE.PERIOD_TYPE

Line 909: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;

905: FROM FPA_AW_PROJS_V
906: WHERE PLANNING_CYCLE = P_PC_ID;
907:
908: l_portfolio_id FPA_AW_PORTF_HEADERS_V.PORTFOLIO%TYPE := null;
909: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;
910: l_class_code_id NUMBER;
911: l_valid_project VARCHAR2(1) := FND_API.G_FALSE;
912: l_validation BOOLEAN := FALSE;
913:

Line 1138: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;

1134: l_level_error BOOLEAN := FALSE;
1135:
1136:
1137: l_portfolio_id FPA_AW_PORTF_HEADERS_V.PORTFOLIO%TYPE := null;
1138: l_current_pc_id FPA_AW_PC_INFO_V.PLANNING_CYCLE%TYPE := null;
1139: l_class_code_id NUMBER;
1140: l_pc_id NUMBER;
1141: l_valid_project VARCHAR2(1) := FND_API.G_FALSE;
1142: l_validation BOOLEAN := FALSE;