APPS.FA_RETIREMENT_PVT dependencies on FA_QUERY_BALANCES_PKG

Line 3442: 'fa_query_balances_pkg.query_balances', p_log_level_rec => p_log_level_rec);

3438: else
3439:
3440: if (p_log_level_rec.statement_level) then
3441: fa_debug_pkg.add(l_calling_fn, 'Call',
3442: 'fa_query_balances_pkg.query_balances', p_log_level_rec => p_log_level_rec);
3443: end if;
3444:
3445: fa_query_balances_pkg.query_balances(
3446: X_asset_id => l_asset_hdr_rec.asset_id,

Line 3445: fa_query_balances_pkg.query_balances(

3441: fa_debug_pkg.add(l_calling_fn, 'Call',
3442: 'fa_query_balances_pkg.query_balances', p_log_level_rec => p_log_level_rec);
3443: end if;
3444:
3445: fa_query_balances_pkg.query_balances(
3446: X_asset_id => l_asset_hdr_rec.asset_id,
3447: X_book => l_asset_hdr_rec.book_type_code,
3448: X_period_ctr => 0,
3449: X_dist_id => 0,

Line 4117: 'fa_query_balances_pkg.query_balances', p_log_level_rec => p_log_level_rec);

4113: if (nvl(l_member_exists, 'N') = 'N' ) then
4114:
4115: if (p_log_level_rec.statement_level) then
4116: fa_debug_pkg.add(l_calling_fn, 'Call',
4117: 'fa_query_balances_pkg.query_balances', p_log_level_rec => p_log_level_rec);
4118: end if;
4119:
4120: fa_query_balances_pkg.query_balances(
4121: X_asset_id => p_asset_id,

Line 4120: fa_query_balances_pkg.query_balances(

4116: fa_debug_pkg.add(l_calling_fn, 'Call',
4117: 'fa_query_balances_pkg.query_balances', p_log_level_rec => p_log_level_rec);
4118: end if;
4119:
4120: fa_query_balances_pkg.query_balances(
4121: X_asset_id => p_asset_id,
4122: X_book => p_book_type_code,
4123: X_period_ctr => 0,
4124: X_dist_id => 0,

Line 4538: 'fa_query_balances_pkg.query_balances', p_log_level_rec => p_log_level_rec);

4534: end if;
4535:
4536: if (p_log_level_rec.statement_level) then
4537: fa_debug_pkg.add(l_calling_fn, 'Call',
4538: 'fa_query_balances_pkg.query_balances', p_log_level_rec => p_log_level_rec);
4539: end if;
4540:
4541: fa_query_balances_pkg.query_balances(
4542: X_asset_id => p_asset_hdr_rec.asset_id,

Line 4541: fa_query_balances_pkg.query_balances(

4537: fa_debug_pkg.add(l_calling_fn, 'Call',
4538: 'fa_query_balances_pkg.query_balances', p_log_level_rec => p_log_level_rec);
4539: end if;
4540:
4541: fa_query_balances_pkg.query_balances(
4542: X_asset_id => p_asset_hdr_rec.asset_id,
4543: X_book => p_asset_hdr_rec.book_type_code,
4544: X_period_ctr => 0,
4545: X_dist_id => 0,

Line 5167: fa_query_balances_pkg.query_balances(

5163: if (p_log_level_rec.statement_level) then
5164: fa_debug_pkg.add(l_calling_fn, 'h_rein_mem_asset_id', h_rein_mem_asset_id,p_log_level_rec);
5165: end if;
5166:
5167: fa_query_balances_pkg.query_balances(
5168: X_asset_id => h_rein_mem_asset_id,
5169: X_book => p_asset_hdr_rec.book_type_code,
5170: X_period_ctr => 0,
5171: X_dist_id => 0,

Line 5442: 'fa_query_balances_pkg.query_balances', p_log_level_rec => p_log_level_rec);

5438: (p_mode = 'RECURR') then
5439:
5440: if (p_log_level_rec.statement_level) then
5441: fa_debug_pkg.add(l_calling_fn, 'Call',
5442: 'fa_query_balances_pkg.query_balances', p_log_level_rec => p_log_level_rec);
5443: end if;
5444: bln_use_cur_asset := FALSE;
5445: if (p_trans_rec.transaction_key = 'MR' OR (p_mode = 'RECURR' AND t_reins_asset_flag(i) = 'NO') ) THEN
5446: /*13805724 - No need to call query balance for retirement,fetched in cursor directly */

Line 5449: fa_query_balances_pkg.query_balances(

5445: if (p_trans_rec.transaction_key = 'MR' OR (p_mode = 'RECURR' AND t_reins_asset_flag(i) = 'NO') ) THEN
5446: /*13805724 - No need to call query balance for retirement,fetched in cursor directly */
5447: if ((p_mode = 'RECURR' AND t_reins_asset_flag(i) = 'NO') ) THEN
5448: bln_other_mem_exists := TRUE;
5449: fa_query_balances_pkg.query_balances(
5450: X_asset_id => t_asset_id(i),
5451: X_book => p_asset_hdr_rec.book_type_code,
5452: X_period_ctr => 0,
5453: X_dist_id => 0,

Line 5662: fa_query_balances_pkg.query_balances(

5658: CLOSE c_get_thid;
5659:
5660: end if;
5661:
5662: fa_query_balances_pkg.query_balances(
5663: X_asset_id => t_asset_id(i),
5664: X_book => p_asset_hdr_rec.book_type_code,
5665: X_period_ctr => 0,
5666: X_dist_id => 0,

Line 6785: fa_query_balances_pkg.query_balances(

6781: l_tot_deprn_reserve := 0;
6782: l_tot_bonus_reserve := 0;
6783: for l_dist in c_inactive_dist
6784: loop
6785: fa_query_balances_pkg.query_balances(
6786: X_asset_id => p_asset_hdr_rec.asset_id,
6787: X_book => p_asset_hdr_rec.book_type_code,
6788: X_period_ctr => 0,
6789: X_dist_id => l_dist.distribution_id,