APPS.JA_CN_VOUCHER_NUM_MIG_PKG dependencies on GL_JE_HEADERS

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