APPS.JA_CN_GL_INTER_VALID_PKG dependencies on JA_CN_DFF_ASSIGNMENTS

Line 289: --,ja_cn_dff_assignments dffa

285: FROM gl_je_lines jel
286: , fun_trx_headers trxh
287: , fun_trx_lines trxl
288: , fun_dist_lines distl
289: --,ja_cn_dff_assignments dffa
290: WHERE distl.dist_id = l_jt_id -- transaction header id
291: AND distl.line_id=trxl.line_id
292: AND trxh.trx_id = trxl.trx_id
293: AND jel.reference_2 = TO_CHAR(trxh.batch_id)

Line 722: ,JA_CN_DFF_ASSIGNMENTS DFF

718: CURSOR c_all_jnl_catg IS
719: SELECT jec.je_category_name catg_name
720: --,jec.user_je_category_name catg_user_name
721: FROM gl_je_categories_tl jec
722: ,JA_CN_DFF_ASSIGNMENTS DFF
723: WHERE DFF.DFF_TITLE_CODE = 'JOCA'
724: AND jec.context = DFF.CONTEXT_CODE
725: AND jec.language = userenv('LANG')
726: AND nvl(DECODE(DFF.ATTRIBUTE_COLUMN, 'ATTRIBUTE1',jec.attribute1, 'ATTRIBUTE2',jec.attribute2,

Line 791: ,ja_cn_dff_assignments dffa

787: 'ATTRIBUTE12',jel.attribute12, 'ATTRIBUTE13',jel.attribute13, 'ATTRIBUTE14',jel.attribute14,
788: 'ATTRIBUTE15',jel.attribute15)
789: ) cash_related_item
790: FROM GL_JE_LINES jel
791: ,ja_cn_dff_assignments dffa
792: ,GL_CODE_COMBINATIONS codecmb --Added for CNAO Enhancement
793: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
794: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
795: -- to locate cash flow item in dff_assignment

Line 976: FROM JA_CN_DFF_ASSIGNMENTS DFF

972: BEGIN
973: SELECT DECODE(nvl(DFF.CONTEXT_CODE, ''), '', 'N',
974: DECODE(nvl(DFF.ATTRIBUTE_COLUMN, ''), '', 'N', 'Y'))
975: INTO l_dff_check
976: FROM JA_CN_DFF_ASSIGNMENTS DFF
977: WHERE DFF.DFF_TITLE_CODE = 'JOCA'
978: AND DFF.CHART_OF_ACCOUNTS_ID=l_coa_id
979: ;
980: EXCEPTION

Line 1006: ,JA_CN_DFF_ASSIGNMENTS DFF

1002: THEN
1003: SELECT distinct jec.je_category_name catg_name
1004: INTO l_jnl_catg
1005: FROM gl_je_categories_tl jec
1006: ,JA_CN_DFF_ASSIGNMENTS DFF
1007: WHERE DFF.DFF_TITLE_CODE = 'JOCA'
1008: AND jec.context = DFF.CONTEXT_CODE
1009: AND jec.language = l_language
1010: AND jec.user_je_category_name = l_journal_ctg

Line 1471: --,JA_CN_DFF_ASSIGNMENTS dff

1467: ,FUN_TRX_BATCHES trxb
1468: ,FUN_TRX_TYPES_TL trxtype
1469: ,HZ_PARTIES party_init
1470: ,HZ_PARTIES party_reci
1471: --,JA_CN_DFF_ASSIGNMENTS dff
1472: WHERE trxh.batch_id=trxb.batch_id
1473: AND trxb.trx_type_id=trxtype.trx_type_id
1474: AND party_init.party_id=trxh.initiator_id
1475: AND party_reci.Party_Id=trxh.recipient_id

Line 1525: ,JA_CN_DFF_ASSIGNMENTS dff

1521: FROM FUN_TRX_LINES trl
1522: ,FUN_DIST_LINES trldist
1523: ,GL_CODE_COMBINATIONS codecmb
1524: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
1525: ,JA_CN_DFF_ASSIGNMENTS dff
1526: WHERE trl.line_id=trldist.line_id
1527: AND trl.trx_id=trldist.trx_id
1528: AND trldist.ccid=codecmb.code_combination_id
1529: AND trl.trx_id=l_trx_id --using variable l_trx_id

Line 1682: FROM JA_CN_DFF_ASSIGNMENTS DFF

1678: BEGIN
1679: SELECT distinct DECODE(nvl(DFF.CONTEXT_CODE, ''), '', 'N',
1680: DECODE(nvl(DFF.ATTRIBUTE_COLUMN, ''), '', 'N', 'Y'))
1681: INTO l_dff_check
1682: FROM JA_CN_DFF_ASSIGNMENTS DFF
1683: WHERE DFF.DFF_TITLE_CODE = 'IITL'
1684: AND DFF.chart_of_accounts_id=l_coa_id
1685: ;
1686: EXCEPTION