DBA Data[Home] [Help]

APPS.IGC_CC_YEP_PROCESS_PKG dependencies on GL_PERIODS_V

Line 993: GL_PERIODS_V B,

989:
990: CURSOR C6 IS
991: SELECT B.PERIOD_NUM, B.PERIOD_NAME , A.CC_PERIOD_STATUS
992: FROM IGC_CC_PERIODS A,
993: GL_PERIODS_V B,
994: GL_SETS_OF_BOOKS C
995: WHERE B.PERIOD_YEAR = p_YEAR
996: AND A.PERIOD_SET_NAME = B.PERIOD_SET_NAME
997: AND B.PERIOD_SET_NAME = C.PERIOD_SET_NAME

Line 1009: GL_PERIODS_V B,

1005:
1006: CURSOR C7 IS
1007: SELECT B.PERIOD_NUM, B.PERIOD_NAME , A.CC_PERIOD_STATUS
1008: FROM IGC_CC_PERIODS A,
1009: GL_PERIODS_V B,
1010: GL_SETS_OF_BOOKS C
1011: WHERE B.PERIOD_YEAR = p_YEAR+1
1012: AND A.PERIOD_SET_NAME = B.PERIOD_SET_NAME
1013: AND B.PERIOD_SET_NAME = C.PERIOD_SET_NAME