APPS.JA_CN_VOUCHER_NUM_MIG_PKG dependencies on JA_CN_JOURNAL_LINES

Line 77: FROM gl_je_headers gjh, ja_cn_journal_lines jcjl

73: jcjl.period_name,
74: gjh.POSTING_ACCT_SEQ_VALUE,
75: jcjl.je_line_num,
76: jcjl.journal_number
77: FROM gl_je_headers gjh, ja_cn_journal_lines jcjl
78: WHERE gjh.je_header_id = jcjl.je_header_id
79: AND jcjl.ledger_id = pn_ledger_id
80: -- CHOLI add this line for CNAO V1 to V2 Upgrade
81: AND jcjl.journal_number IS NOT NULL

Line 111: FROM gl_je_headers gjh, ja_cn_journal_lines jcjl

107: jcjl.period_name,
108: gjh.POSTING_ACCT_SEQ_VALUE,
109: jcjl.je_line_num,
110: jcjl.journal_number
111: FROM gl_je_headers gjh, ja_cn_journal_lines jcjl
112: WHERE gjh.je_header_id = jcjl.je_header_id
113: AND jcjl.ledger_id = pn_ledger_id
114: -- CHOLI add this line for CNAO V1 to V2 Upgrade
115: AND jcjl.journal_number IS NOT NULL

Line 148: FROM gl_je_headers gjh, ja_cn_journal_lines jcjl

144: BEGIN
145:
146: SELECT COUNT(*) --Add for bug 11670727, to judge the migration amount is more then 0 or not
147: INTO ln_bsv_mig_num
148: FROM gl_je_headers gjh, ja_cn_journal_lines jcjl
149: WHERE gjh.je_header_id = jcjl.je_header_id
150: AND jcjl.ledger_id = pn_ledger_id
151: --AND jcjl.status = 'P'
152: AND gjh.period_name = pv_period_name

Line 171: FROM gl_je_headers gjh, ja_cn_journal_lines jcjl

167: AND jcvn.period_name = pv_period_name);
168:
169: SELECT COUNT(*)
170: INTO ln_no_bsv_mig_num
171: FROM gl_je_headers gjh, ja_cn_journal_lines jcjl
172: WHERE gjh.je_header_id = jcjl.je_header_id
173: AND jcjl.ledger_id = pn_ledger_id
174: --AND jcjl.status = 'P'
175: AND gjh.period_name = pv_period_name

Line 324: from ja_cn_journal_lines

320: WHERE application_id = 101
321: AND ledger_id = pn_ledger_id
322: AND period_name in
323: (select distinct period_name
324: from ja_cn_journal_lines
325: where ledger_id = pn_ledger_id
326: and legal_entity_id = pn_legal_entity_id)
327: AND adjustment_period_flag = 'N'
328: AND closing_status <> 'N'

Line 414: from ja_cn_journal_lines

410: WHERE application_id = 101
411: AND ledger_id = P_LEDGER_ID
412: AND period_name in
413: (select distinct period_name
414: from ja_cn_journal_lines
415: where ledger_id = P_LEDGER_ID
416: and legal_entity_id = P_LEGAL_ENTITY_ID)
417: AND closing_status <> 'N'
418: AND closing_status <> 'F'