DBA Data[Home] [Help]

APPS.JA_CN_CFS_CALCULATE_PKG dependencies on JA_CN_CFS_ASSIGNMENTS_ALL

Line 352: ja_cn_cfs_assignments_all jccaa

348: OR
349: EXISTS (SELECT
350: jccaa.axis_seq
351: FROM
352: ja_cn_cfs_assignments_all jccaa
353: WHERE jccaa.chart_of_accounts_id=l_coa
354: AND rra.axis_set_id=jccaa.axis_set_id
355: AND jccaa.axis_seq=rra.axis_seq
356: )

Line 890: ja_cn_cfs_assignments_all jccaa

886: ,rra.display_zero_amount_flag
887: ,rra.change_sign_flag
888: ,rra.display_format
889: FROM
890: ja_cn_cfs_assignments_all jccaa
891: ,rg_report_axes rra
892: WHERE jccaa.chart_of_accounts_id=l_coa
893: AND jccaa.axis_set_id=l_axis_set_id
894: AND rra.axis_set_id=jccaa.axis_set_id

Line 999: --JA_CN_CFS_ASSIGNMENTS_ALL for current legal entity and row set, and not in the table 'ja_cn_cfs_row_cgs_gt'

995: --Assignment form, they should be regarded as most detailed items for main part of Cash Flow Statement. Insert
996: --these rows into the temporary table 'ja_cn_cfs_row_cgs_gt' with type 'C' after they are identified
997:
998: --So rows that are most detailed item for main part of Cash flow statement, shoud be those in the table
999: --JA_CN_CFS_ASSIGNMENTS_ALL for current legal entity and row set, and not in the table 'ja_cn_cfs_row_cgs_gt'
1000: FOR l_axis_seq_cfs IN c_axis_seq_cfs
1001: LOOP
1002: INSERT
1003: INTO

Line 1171: -- to assignment in the table 'JA_CN_CFS_ASSIGNMENTS_ALL' and amount of detailed

1167: -- DESCRIPTION:
1168: --
1169: -- The procedure 'Calculate_Row_Amount' is used to calculate amount for a
1170: -- specific cash flow item in the main part of cash flow statement according
1171: -- to assignment in the table 'JA_CN_CFS_ASSIGNMENTS_ALL' and amount of detailed
1172: -- cash flow item in the table 'JA_CN_CFS_ACTIVITIES_ALL'.
1173: --
1174: -- PARAMETERS:
1175: -- In: p_legal_entity_id Identifier of legal entity

Line 1288: ja_cn_cfs_assignments_all

1284: -- added for CNAO Enhancement end
1285: AND detailed_cfs_item IN (SELECT
1286: detailed_cfs_item
1287: FROM
1288: ja_cn_cfs_assignments_all
1289: WHERE chart_of_accounts_id=p_coa --updated by lyb
1290: AND axis_set_id=l_axis_set_id
1291: AND axis_seq=l_axis_seq
1292: );