DBA Data[Home] [Help]

APPS.JA_CN_AP_PBD_EXPORT_PKG dependencies on JA_CN_VOUCHER_NUMBER

Line 812: --Add ja_cn_voucher_number table, voucher number and legal entity

808: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
809:
810: CURSOR journal_num_cur IS
811: --Update by Jianchao Chi, for cnaov2 upgrade 06-JAN-2011
812: --Add ja_cn_voucher_number table, voucher number and legal entity
813: --are fetched from ja_cn_voucher_number
814: --The new one is
815: SELECT DISTINCT voucher_number journal_number
816: FROM ja_cn_voucher_number

Line 813: --are fetched from ja_cn_voucher_number

809:
810: CURSOR journal_num_cur IS
811: --Update by Jianchao Chi, for cnaov2 upgrade 06-JAN-2011
812: --Add ja_cn_voucher_number table, voucher number and legal entity
813: --are fetched from ja_cn_voucher_number
814: --The new one is
815: SELECT DISTINCT voucher_number journal_number
816: FROM ja_cn_voucher_number
817: WHERE je_header_id = pn_je_header_id

Line 816: FROM ja_cn_voucher_number

812: --Add ja_cn_voucher_number table, voucher number and legal entity
813: --are fetched from ja_cn_voucher_number
814: --The new one is
815: SELECT DISTINCT voucher_number journal_number
816: FROM ja_cn_voucher_number
817: WHERE je_header_id = pn_je_header_id
818: AND legal_entity_id = pn_legal_entity_id;
819: --Comment by Jianchao Chi for V2 Upgrade, 06-JAN-2011
820: --get the journal number from ja_vn_voucher_number