APPS.IGI_IGIGCBGD_XMLP_PKG dependencies on GL_PERIODS

Line 62: GL_PERIODS GP,

58: SELECT
59: GP.PERIOD_NAME
60: INTO P_FROM_PERIOD
61: FROM
62: GL_PERIODS GP,
63: GL_SETS_OF_BOOKS GSOB
64: WHERE GSOB.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
65: AND GSOB.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
66: AND GP.PERIOD_TYPE = GSOB.ACCOUNTED_PERIOD_TYPE

Line 72: GL_PERIODS G,

68: AND GP.PERIOD_YEAR = (
69: SELECT
70: G.PERIOD_YEAR
71: FROM
72: GL_PERIODS G,
73: GL_SETS_OF_BOOKS GS
74: WHERE GS.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
75: AND GS.PERIOD_SET_NAME = G.PERIOD_SET_NAME
76: AND G.PERIOD_NAME = P_TO_PERIOD );

Line 84: GL_PERIODS GP,

80: GP.PERIOD_NUM,
81: GP.PERIOD_YEAR
82: INTO LP_FROM_PERIOD_NUM,LP_FROM_PERIOD_YEAR
83: FROM
84: GL_PERIODS GP,
85: GL_SETS_OF_BOOKS GS
86: WHERE GP.PERIOD_NAME = P_FROM_PERIOD
87: AND GP.PERIOD_SET_NAME = GS.PERIOD_SET_NAME
88: AND GS.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;

Line 94: GL_PERIODS GP,

90: GP.PERIOD_NUM,
91: GP.PERIOD_YEAR
92: INTO LP_TO_PERIOD_NUM,LP_TO_PERIOD_YEAR
93: FROM
94: GL_PERIODS GP,
95: GL_SETS_OF_BOOKS GSOB
96: WHERE GP.PERIOD_SET_NAME = GSOB.PERIOD_SET_NAME
97: AND GSOB.SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
98: AND GP.PERIOD_NAME = P_TO_PERIOD;