APPS.IGI_IGIGCBGD_XMLP_PKG dependencies on GL_PERIOD_STATUSES

Line 12: GL_PERIOD_STATUSES

8: SELECT
9: EFFECTIVE_PERIOD_NUM
10: INTO CP_EFFECTIVE_PERIOD_FROM
11: FROM
12: GL_PERIOD_STATUSES
13: WHERE APPLICATION_ID = 101
14: AND SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
15: AND PERIOD_NAME = LP_FROM_PERIOD;
16: ELSE

Line 21: GL_PERIOD_STATUSES

17: SELECT
18: MIN(EFFECTIVE_PERIOD_NUM)
19: INTO CP_EFFECTIVE_PERIOD_FROM
20: FROM
21: GL_PERIOD_STATUSES
22: WHERE APPLICATION_ID = 101
23: AND SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;
24: END IF;
25: IF P_TO_PERIOD IS NOT NULL THEN

Line 30: GL_PERIOD_STATUSES

26: SELECT
27: EFFECTIVE_PERIOD_NUM
28: INTO CP_EFFECTIVE_PERIOD_TO
29: FROM
30: GL_PERIOD_STATUSES
31: WHERE APPLICATION_ID = 101
32: AND SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID
33: AND PERIOD_NAME = P_TO_PERIOD;
34: ELSE

Line 39: GL_PERIOD_STATUSES

35: SELECT
36: MAX(EFFECTIVE_PERIOD_NUM)
37: INTO CP_EFFECTIVE_PERIOD_TO
38: FROM
39: GL_PERIOD_STATUSES
40: WHERE APPLICATION_ID = 101
41: AND SET_OF_BOOKS_ID = P_SET_OF_BOOKS_ID;
42: END IF;
43: RETURN (TRUE);

Line 165: FROM gl_period_statuses gls

161: , gjh.je_source Journal_Source
162: , gjl.description Description
163: , gjl.effective_date Effective_Date
164: , (nvl(gjl.accounted_dr,0) - nvl(gjl.accounted_cr,0)) Amount
165: FROM gl_period_statuses gls
166: -- , igi_com_gl_batches_copy_v jgb -- bug 6315298
167: , gl_je_batches gjb , gl_lookups l -- bug 6315298
168: , gl_code_combinations gcc
169: , gl_je_headers gjh

Line 200: FROM gl_period_statuses gls

196: , gjh.je_source Journal_Source
197: , gjl.description Description
198: , gjl.effective_date Effective_Date
199: , (nvl(gjl.accounted_dr,0) - nvl(gjl.accounted_cr,0)) Amount
200: FROM gl_period_statuses gls
201: -- , igi_com_gl_batches_copy_v jgb -- bug 6315298
202: , gl_je_batches gjb, gl_lookups l -- bug 6315298
203: , gl_code_combinations gcc
204: , gl_je_headers gjh