APPS.JA_CN_AB_EXP_PKG dependencies on JA_CN_ACCOUNT_BALANCES_GT

Line 92: l_account_balances_gbl_tmp_row ja_cn_account_balances_gt%ROWTYPE;

88: l_attribute_column4balanceside ja_cn_dff_assignments.attribute_column%TYPE;
89: l_attribute_column4account_lev ja_cn_dff_assignments.attribute_column%TYPE;
90: l_account_segment ja_cn_journal_lines.account_segment%TYPE;
91: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;
92: l_account_balances_gbl_tmp_row ja_cn_account_balances_gt%ROWTYPE;
93: l_sql_stmt VARCHAR2(30000) := '';
94:
95: l_sql_stmt4insert_j_line VARCHAR2(30000) := 'INSERT INTO ja_cn_account_balances_gt
96: (account_segment,

Line 95: l_sql_stmt4insert_j_line VARCHAR2(30000) := 'INSERT INTO ja_cn_account_balances_gt

91: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;
92: l_account_balances_gbl_tmp_row ja_cn_account_balances_gt%ROWTYPE;
93: l_sql_stmt VARCHAR2(30000) := '';
94:
95: l_sql_stmt4insert_j_line VARCHAR2(30000) := 'INSERT INTO ja_cn_account_balances_gt
96: (account_segment,
97: currency_code,
98: func_begin_balance,
99: orig_begin_balance,

Line 246: FROM ja_cn_account_balances_gt

242: SELECT * FROM ja_cn_subsidiary_gt;
243:
244: CURSOR c_in_account_balances_gbl_tmp IS
245: SELECT *
246: FROM ja_cn_account_balances_gt
247: ORDER BY start_date
248: ,ACCOUNT_SEGMENT
249: ,PROJECT_NUMBER
250: ,THIRD_PARTY_NUMBER

Line 673: FROM ja_cn_account_balances_gt

669: l_account_balances_gbl_tmp_row.is_foreign <>
670: l_functional_currency_code THEN
671: SELECT COUNT(*)
672: INTO l_number_a
673: FROM ja_cn_account_balances_gt
674: WHERE account_segment = l_account_balances_gbl_tmp_row.account_segment
675: AND nvl(COST_CENTER, 'NULL') =
676: nvl(l_account_balances_gbl_tmp_row.COST_CENTER, 'NULL')
677: AND nvl(THIRD_PARTY_NUMBER, 'NULL') =

Line 745: FROM ja_cn_account_balances_gt

741: ,BALANCE_SIDE
742: ,ACCOUNT_LEVEL
743: ,period_name
744: ,start_date
745: FROM ja_cn_account_balances_gt
746: WHERE account_segment =
747: l_account_balances_gbl_tmp_row.account_segment
748: AND nvl(COST_CENTER, 'NULL') =
749: nvl(l_account_balances_gbl_tmp_row.COST_CENTER, 'NULL')

Line 833: FROM ja_cn_account_balances_gt

829: ,BALANCE_SIDE
830: ,ACCOUNT_LEVEL
831: ,period_name
832: ,start_date
833: FROM ja_cn_account_balances_gt
834: WHERE account_segment =
835: l_ja_cn_subsidiary_gbl_tmp_row.account_segment_value
836: AND currency_code <>
837: (SELECT fnd_currencies_vl.NAME