eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_FACTS_EDIT_CHECK dependencies on FV_FACTS2_RETAIN_BAL

Line 1448: FROM fv_facts2_retain_bal bal,

1444: IS
1445: SELECT bal.ending_bal,
1446: bal.ussgl_account ,
1447: bal.authority_type
1448: FROM fv_facts2_retain_bal bal,
1449: fv_facts2_closing_validation clos
1450: WHERE bal.treasury_symbol_id = g_treasury_symbol_id
1451: AND clos.closing_grp = p_closing_grp
1452: AND bal.closing_grp = p_closing_grp

Line 3054: -- If there is an entry then empty the FV_FACTS2_RETAIN_BAL table

3050: l_closing_grp VARCHAR2(2);
3051: BEGIN
3052: l_module_name := g_module_name || 'populate_bal_ret_tbl';
3053: -- Checking for the period entry in fv_Facts2_edit_params table
3054: -- If there is an entry then empty the FV_FACTS2_RETAIN_BAL table
3055: --fnd_file.put_line(fnd_file.log , '**********************POPULATE RETAIN BAL 13 BEGIN ************');
3056: SELECT COUNT(*)
3057: INTO l_rec_exists
3058: FROM fv_Facts2_edit_params

Line 3070: FROM FV_FACTS2_RETAIN_BAL

3066: --fnd_file.put_line(fnd_file.log , '**********************l_rec_exists ::'||l_rec_exists);
3067: IF (l_rec_exists = 1) THEN
3068: BEGIN
3069: DELETE
3070: FROM FV_FACTS2_RETAIN_BAL
3071: WHERE treasury_symbol_id = g_treasury_symbol_id
3072: AND period_year <> g_period_year-1;
3073: EXCEPTION
3074: WHEN NO_DATA_FOUND THEN

Line 3088: -- Using cursor ret_bal_c to populate the fv_facts2_retain_bal table

3084: AND tmp.sgl_acct_number = att.ussgl_acct_number
3085: AND tmp.sgl_acct_number = clos.ussgl_Account
3086: AND clos.closing_grp IS NOT NULL;*/
3087: --fnd_file.put_line(fnd_file.log , l_module_name||'l_count ::'||l_count);
3088: -- Using cursor ret_bal_c to populate the fv_facts2_retain_bal table
3089: FOR ret_bal_rec IN ret_bal_c
3090: LOOP
3091: l_end_bal :=ret_bal_rec.amount;
3092: l_ussgl_account:=ret_bal_rec.sgl_acct_number;

Line 3101: -- Inserting the ending balance values to FV_FACTS2_RETAIN_BAL table

3097: /*fnd_file.put_line(fnd_file.log , l_module_name||'l_end_bal ::'||l_end_bal);
3098: fnd_file.put_line(fnd_file.log , l_module_name||'l_ussgl_account ::'||l_ussgl_account);
3099: fnd_file.put_line(fnd_file.log , l_module_name||'l_treasury_symb ::'||l_treasury_symb);
3100: fnd_file.put_line(fnd_file.log , l_module_name||'l_auth_type ::'||l_auth_type);*/
3101: -- Inserting the ending balance values to FV_FACTS2_RETAIN_BAL table
3102: INSERT
3103: INTO FV_FACTS2_RETAIN_BAL
3104: (
3105: USSGL_ACCOUNT ,

Line 3103: INTO FV_FACTS2_RETAIN_BAL

3099: fnd_file.put_line(fnd_file.log , l_module_name||'l_treasury_symb ::'||l_treasury_symb);
3100: fnd_file.put_line(fnd_file.log , l_module_name||'l_auth_type ::'||l_auth_type);*/
3101: -- Inserting the ending balance values to FV_FACTS2_RETAIN_BAL table
3102: INSERT
3103: INTO FV_FACTS2_RETAIN_BAL
3104: (
3105: USSGL_ACCOUNT ,
3106: TREASURY_SYMBOL_ID,
3107: AUTHORITY_TYPE ,