DBA Data[Home] [Help]

APPS.GL_CASH_CLR_ACCT_ANAL_RPT_PKG dependencies on GL_PERIOD_STATUSES

Line 35: FROM gl_period_statuses gps

31: ,MAX(CASE gps.period_name
32: WHEN period_to_param THEN gps.effective_period_num END)
33: INTO gn_effective_period_num_from
34: ,gn_effective_period_num_to
35: FROM gl_period_statuses gps
36: WHERE gps.ledger_id = ledger_id_param
37: AND gps.application_id = 200
38: AND gps.period_name IN (period_from_param, period_to_param);
39:

Line 57: ,gl_period_statuses gps

53: ,xla_ae_lines xal
54: ,xla_ae_headers xah
55: ,xla_transaction_entities xte
56: ,ap_checks_all aca
57: ,gl_period_statuses gps
58: WHERE
59: gjl.ledger_id = :ledger_id_param
60: AND gjl.code_combination_id = :ccid
61: AND gps.ledger_id = gjl.ledger_id

Line 96: ,gl_period_statuses gps

92: ,xla_ae_lines xal
93: ,xla_ae_headers xah
94: ,xla_transaction_entities xte
95: ,ap_checks_all aca
96: ,gl_period_statuses gps
97: WHERE
98: gjl.ledger_id = :ledger_id_param
99: AND gjl.code_combination_id = :ccid
100: AND gps.ledger_id = gjl.ledger_id

Line 135: ,gl_period_statuses gps

131: FROM
132: gl_je_lines gjl
133: ,gl_je_headers gjh
134: ,gl_je_batches gjb
135: ,gl_period_statuses gps
136: WHERE
137: gjl.ledger_id = :ledger_id_param
138: AND gjl.code_combination_id = :ccid
139: AND gps.ledger_id = gjl.ledger_id

Line 163: ,gl_period_statuses gps

159: FROM
160: gl_je_lines gjl
161: ,gl_je_headers gjh
162: ,gl_je_batches gjb
163: ,gl_period_statuses gps
164: WHERE
165: gjl.ledger_id = :ledger_id_param
166: AND gjl.code_combination_id = :ccid
167: AND gps.ledger_id = gjl.ledger_id

Line 198: ,gl_period_statuses gps

194: ,xla_ae_lines xal
195: ,xla_ae_headers xah
196: ,xla_transaction_entities xte
197: ,ap_checks_all aca
198: ,gl_period_statuses gps
199: WHERE
200: gjl.ledger_id = :ledger_id_param
201: AND gjl.code_combination_id = :ccid
202: AND gps.ledger_id = gjl.ledger_id

Line 237: ,gl_period_statuses gps

233: ,xla_ae_lines xal
234: ,xla_ae_headers xah
235: ,xla_transaction_entities xte
236: ,ap_checks_all aca
237: ,gl_period_statuses gps
238: WHERE
239: gjl.ledger_id = :ledger_id_param
240: AND gjl.code_combination_id = :ccid
241: AND gps.ledger_id = gjl.ledger_id