APPS.JA_CN_AR_VALIDATION_PKG dependencies on GL_PERIOD_STATUSES

Line 109: GL_PERIOD_STATUSES gps,

105: XLA_AE_HEADERS aeh,
106: JA_CN_CODE_COMBINATION_V jcc,
107: HZ_CUST_ACCOUNTS cust,
108: HZ_PARTIES part,
109: GL_PERIOD_STATUSES gps,
110: Xla_Transaction_Entities ent,
111: RA_CUSTOMER_TRX_ALL rct
112: WHERE jeh.je_header_id = jel.je_header_id
113: AND jeh.je_header_id = gir.je_header_id

Line 169: GL_PERIOD_STATUSES gps

165: XLA_AE_HEADERS aeh,
166: JA_CN_CODE_COMBINATION_V jcc,
167: HZ_CUST_ACCOUNTS cust,
168: HZ_PARTIES part,
169: GL_PERIOD_STATUSES gps
170: WHERE jeh.je_header_id = jel.je_header_id
171: AND jeh.je_header_id = gir.je_header_id
172: AND jel.je_line_num = gir.je_line_num
173: AND gir.gl_sl_link_id = ael.gl_sl_link_id

Line 291: FROM GL_PERIOD_STATUSES

287: IF pv_period_from IS NOT NULL
288: THEN
289: SELECT start_date
290: INTO ld_start_date
291: FROM GL_PERIOD_STATUSES
292: WHERE ledger_id = pn_ledger_id
293: AND application_id = 101
294: AND period_name = pv_period_from
295: AND to_char(period_year) = pv_accounting_year;

Line 304: FROM GL_PERIOD_STATUSES

300: IF pv_period_to IS NOT NULL
301: THEN
302: SELECT end_date
303: INTO ld_end_date
304: FROM GL_PERIOD_STATUSES
305: WHERE ledger_id = pn_ledger_id
306: AND application_id = 101
307: AND period_name = pv_period_to
308: AND to_char(period_year) = pv_accounting_year;