DBA Data[Home] [Help]

APPS.PA_CAP_INT_PVT dependencies on PA_IND_COST_MULTIPLIERS

Line 1306: ln_rate_mult pa_ind_cost_multipliers.multiplier%TYPE;

1302: ln_period_num gl_period_statuses.period_num%TYPE;
1303:
1304: ln_curr_period_mult NUMBER;
1305: ln_period_mult NUMBER;
1306: ln_rate_mult pa_ind_cost_multipliers.multiplier%TYPE;
1307:
1308: ln_run_id pa_alloc_runs_all.run_id%TYPE;
1309: lv_exp_org_source pa_cint_rate_info_all.exp_org_source%TYPE;
1310: lv_interest_calc_method pa_cint_rate_info_all.interest_calculation_method%TYPE;

Line 1386: ,pa_ind_cost_multipliers pccm

1382: FROM pa_projects pp
1383: ,pa_ind_rate_schedules_all_bg pirs
1384: ,pa_ind_rate_sch_revisions pirsv
1385: /* Bug fix:3208751 ,pa_cint_rate_multipliers pccm
1386: ,pa_ind_cost_multipliers pccm
1387: WHERE pp.cint_rate_sch_id = pirs.ind_rate_sch_id
1388: AND pirs.ind_rate_sch_usage = 'CAPITALIZED_INTEREST'
1389: AND pirs.ind_rate_sch_id = pirsv.ind_rate_sch_id
1390: AND pccm.ind_rate_sch_revision_id = pirsv.ind_rate_sch_revision_id

Line 1423: ,pa_ind_cost_multipliers pccm

1419: FROM pa_cint_rate_info pcri
1420: ,pa_ind_cost_codes picc
1421: ,pa_ind_rate_schedules_all_bg pirs
1422: ,pa_ind_rate_sch_revisions pirsv
1423: ,pa_ind_cost_multipliers pccm
1424: WHERE pcri.ind_cost_code = picc.ind_cost_code
1425: AND picc.ind_cost_code_usage = 'CAPITALIZED_INTEREST'
1426: AND (trunc(g_period_end_date) BETWEEN trunc(picc.start_date_active)
1427: AND trunc(nvl(picc.end_date_active,g_period_end_date)))