APPS.JA_CN_GL_INTER_VALID_PKG dependencies on JA_CN_DFF_ASSIGNMENTS

Line 286: ,ja_cn_dff_assignments dffa

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

Line 717: ,JA_CN_DFF_ASSIGNMENTS DFF

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

Line 784: ,ja_cn_dff_assignments dffa

780: 'ATTRIBUTE12',jel.attribute12, 'ATTRIBUTE13',jel.attribute13, 'ATTRIBUTE14',jel.attribute14,
781: 'ATTRIBUTE15',jel.attribute15)
782: ) cash_related_item
783: FROM GL_JE_LINES jel
784: ,ja_cn_dff_assignments dffa
785: ,GL_CODE_COMBINATIONS codecmb --Added for CNAO Enhancement
786: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
787: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
788: -- to locate cash flow item in dff_assignment

Line 939: FROM JA_CN_DFF_ASSIGNMENTS DFF

935: BEGIN
936: SELECT DECODE(nvl(DFF.CONTEXT_CODE, ''), '', 'N',
937: DECODE(nvl(DFF.ATTRIBUTE_COLUMN, ''), '', 'N', 'Y'))
938: INTO l_dff_check
939: FROM JA_CN_DFF_ASSIGNMENTS DFF
940: WHERE DFF.DFF_TITLE_CODE = 'JOCA'
941: AND DFF.CHART_OF_ACCOUNTS_ID=l_coa_id
942: ;
943: EXCEPTION

Line 969: ,JA_CN_DFF_ASSIGNMENTS DFF

965: THEN
966: SELECT distinct jec.je_category_name catg_name
967: INTO l_jnl_catg
968: FROM gl_je_categories_tl jec
969: ,JA_CN_DFF_ASSIGNMENTS DFF
970: WHERE DFF.DFF_TITLE_CODE = 'JOCA'
971: AND jec.context = DFF.CONTEXT_CODE
972: AND jec.language = l_language
973: AND jec.user_je_category_name = l_journal_ctg

Line 1434: --,JA_CN_DFF_ASSIGNMENTS dff

1430: ,FUN_TRX_BATCHES trxb
1431: ,FUN_TRX_TYPES_TL trxtype
1432: ,HZ_PARTIES party_init
1433: ,HZ_PARTIES party_reci
1434: --,JA_CN_DFF_ASSIGNMENTS dff
1435: WHERE trxh.batch_id=trxb.batch_id
1436: AND trxb.trx_type_id=trxtype.trx_type_id
1437: AND party_init.party_id=trxh.initiator_id
1438: AND party_reci.Party_Id=trxh.recipient_id

Line 1488: ,JA_CN_DFF_ASSIGNMENTS dff

1484: FROM FUN_TRX_LINES trl
1485: ,FUN_DIST_LINES trldist
1486: ,GL_CODE_COMBINATIONS codecmb
1487: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
1488: ,JA_CN_DFF_ASSIGNMENTS dff
1489: WHERE trl.line_id=trldist.line_id
1490: AND trl.trx_id=trldist.trx_id
1491: AND trldist.ccid=codecmb.code_combination_id
1492: AND trl.trx_id=l_trx_id --using variable l_trx_id

Line 1645: FROM JA_CN_DFF_ASSIGNMENTS DFF

1641: BEGIN
1642: SELECT distinct DECODE(nvl(DFF.CONTEXT_CODE, ''), '', 'N',
1643: DECODE(nvl(DFF.ATTRIBUTE_COLUMN, ''), '', 'N', 'Y'))
1644: INTO l_dff_check
1645: FROM JA_CN_DFF_ASSIGNMENTS DFF
1646: WHERE DFF.DFF_TITLE_CODE = 'IITL'
1647: AND DFF.chart_of_accounts_id=l_coa_id
1648: ;
1649: EXCEPTION