APPS.IGI_IGIGCBGD_XMLP_PKG dependencies on GL_SETS_OF_BOOKS

Line 63: GL_SETS_OF_BOOKS GSOB

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
67: AND GP.PERIOD_NUM = 1

Line 73: GL_SETS_OF_BOOKS GS

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 );
77: END IF;

Line 85: GL_SETS_OF_BOOKS GS

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;
89: SELECT

Line 95: GL_SETS_OF_BOOKS GSOB

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;
99: SELECT

Line 104: GL_SETS_OF_BOOKS

100: NAME,
101: CURRENCY_CODE
102: INTO LP_LEDGER_NAME,LP_CURRENCY_CODE
103: FROM
104: GL_SETS_OF_BOOKS
105: WHERE SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;
106: SELECT
107: NAME
108: INTO LP_CASH_SOB_NAME

Line 110: GL_SETS_OF_BOOKS

106: SELECT
107: NAME
108: INTO LP_CASH_SOB_NAME
109: FROM
110: GL_SETS_OF_BOOKS
111: WHERE SET_OF_BOOKS_ID = P_CASH_SOB_ID;
112: SELECT
113: count(*)
114: INTO LP_UNPOSTED_JOURNALS