APPS.IGI_IGIPCBAP_XMLP_PKG dependencies on GL_PERIODS

Line 44: GL_PERIODS GP,

40: GP.END_DATE,
41: GSOB.CURRENCY_CODE
42: INTO LP_END_DATE,LP_CURRENCY_CODE
43: FROM
44: GL_PERIODS GP,
45: GL_SETS_OF_BOOKS GSOB
46: WHERE GSOB.SET_OF_BOOKS_ID = P_SOB_ID
47: AND GSOB.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
48: AND GP.PERIOD_NAME = P_TO_PERIOD;

Line 54: GL_PERIODS GP,

50: SELECT
51: GP.START_DATE
52: INTO LP_START_DATE
53: FROM
54: GL_PERIODS GP,
55: GL_SETS_OF_BOOKS GSOB
56: WHERE GSOB.SET_OF_BOOKS_ID = P_SOB_ID
57: AND GSOB.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
58: AND GP.PERIOD_NAME = P_FROM_PERIOD;

Line 64: GL_PERIODS GP,

60: SELECT
61: GP.START_DATE
62: INTO LP_START_DATE
63: FROM
64: GL_PERIODS GP,
65: GL_SETS_OF_BOOKS GSOB
66: WHERE GSOB.SET_OF_BOOKS_ID = P_SOB_ID
67: AND GSOB.PERIOD_SET_NAME = GP.PERIOD_SET_NAME
68: AND GP.PERIOD_NUM = 1

Line 74: GL_PERIODS G,

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