DBA Data[Home] [Help]

APPS.PA_CAP_INT_PVT dependencies on PA_CINT_RATE_INFO

Line 1309: lv_exp_org_source pa_cint_rate_info_all.exp_org_source%TYPE;

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;
1311: lv_threshold_amt_type pa_cint_rate_info_all.threshold_amt_type%TYPE;
1312: ln_proj_duration_threshold pa_cint_rate_info_all.proj_duration_threshold%TYPE;
1313: ln_proj_amt_threshold pa_cint_rate_info_all.proj_amt_threshold%TYPE;

Line 1310: lv_interest_calc_method pa_cint_rate_info_all.interest_calculation_method%TYPE;

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;
1311: lv_threshold_amt_type pa_cint_rate_info_all.threshold_amt_type%TYPE;
1312: ln_proj_duration_threshold pa_cint_rate_info_all.proj_duration_threshold%TYPE;
1313: ln_proj_amt_threshold pa_cint_rate_info_all.proj_amt_threshold%TYPE;
1314: ln_task_duration_threshold pa_cint_rate_info_all.task_duration_threshold%TYPE;

Line 1311: lv_threshold_amt_type pa_cint_rate_info_all.threshold_amt_type%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;
1311: lv_threshold_amt_type pa_cint_rate_info_all.threshold_amt_type%TYPE;
1312: ln_proj_duration_threshold pa_cint_rate_info_all.proj_duration_threshold%TYPE;
1313: ln_proj_amt_threshold pa_cint_rate_info_all.proj_amt_threshold%TYPE;
1314: ln_task_duration_threshold pa_cint_rate_info_all.task_duration_threshold%TYPE;
1315: ln_task_amt_threshold pa_cint_rate_info_all.task_amt_threshold%TYPE;

Line 1312: ln_proj_duration_threshold pa_cint_rate_info_all.proj_duration_threshold%TYPE;

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;
1311: lv_threshold_amt_type pa_cint_rate_info_all.threshold_amt_type%TYPE;
1312: ln_proj_duration_threshold pa_cint_rate_info_all.proj_duration_threshold%TYPE;
1313: ln_proj_amt_threshold pa_cint_rate_info_all.proj_amt_threshold%TYPE;
1314: ln_task_duration_threshold pa_cint_rate_info_all.task_duration_threshold%TYPE;
1315: ln_task_amt_threshold pa_cint_rate_info_all.task_amt_threshold%TYPE;
1316:

Line 1313: ln_proj_amt_threshold pa_cint_rate_info_all.proj_amt_threshold%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;
1311: lv_threshold_amt_type pa_cint_rate_info_all.threshold_amt_type%TYPE;
1312: ln_proj_duration_threshold pa_cint_rate_info_all.proj_duration_threshold%TYPE;
1313: ln_proj_amt_threshold pa_cint_rate_info_all.proj_amt_threshold%TYPE;
1314: ln_task_duration_threshold pa_cint_rate_info_all.task_duration_threshold%TYPE;
1315: ln_task_amt_threshold pa_cint_rate_info_all.task_amt_threshold%TYPE;
1316:
1317: ln_proj_owning_org_id pa_projects_all.carrying_out_organization_id%TYPE;

Line 1314: ln_task_duration_threshold pa_cint_rate_info_all.task_duration_threshold%TYPE;

1310: lv_interest_calc_method pa_cint_rate_info_all.interest_calculation_method%TYPE;
1311: lv_threshold_amt_type pa_cint_rate_info_all.threshold_amt_type%TYPE;
1312: ln_proj_duration_threshold pa_cint_rate_info_all.proj_duration_threshold%TYPE;
1313: ln_proj_amt_threshold pa_cint_rate_info_all.proj_amt_threshold%TYPE;
1314: ln_task_duration_threshold pa_cint_rate_info_all.task_duration_threshold%TYPE;
1315: ln_task_amt_threshold pa_cint_rate_info_all.task_amt_threshold%TYPE;
1316:
1317: ln_proj_owning_org_id pa_projects_all.carrying_out_organization_id%TYPE;
1318: ln_sched_version_id pa_ind_rate_sch_revisions.ind_rate_sch_revision_id%TYPE;

Line 1315: ln_task_amt_threshold pa_cint_rate_info_all.task_amt_threshold%TYPE;

1311: lv_threshold_amt_type pa_cint_rate_info_all.threshold_amt_type%TYPE;
1312: ln_proj_duration_threshold pa_cint_rate_info_all.proj_duration_threshold%TYPE;
1313: ln_proj_amt_threshold pa_cint_rate_info_all.proj_amt_threshold%TYPE;
1314: ln_task_duration_threshold pa_cint_rate_info_all.task_duration_threshold%TYPE;
1315: ln_task_amt_threshold pa_cint_rate_info_all.task_amt_threshold%TYPE;
1316:
1317: ln_proj_owning_org_id pa_projects_all.carrying_out_organization_id%TYPE;
1318: ln_sched_version_id pa_ind_rate_sch_revisions.ind_rate_sch_revision_id%TYPE;
1319: lv_cip_cost_type pa_project_types_all.capital_cost_type_code%TYPE;

Line 1364: FROM pa_cint_rate_info pcri

1360: ,pcri.curr_period_convention curr_period_convention
1361: ,pcri.interest_calculation_method interest_calc_method
1362: ,pcri.period_rate_code period_rate_code
1363: ,pcri.fin_plan_type_id fin_plan_type_id
1364: FROM pa_cint_rate_info pcri
1365: ,pa_ind_cost_codes picc
1366: WHERE pcri.ind_cost_code = picc.ind_cost_code
1367: AND picc.ind_cost_code_usage = 'CAPITALIZED_INTEREST'
1368: /* Start Bug fix :3028240

Line 1419: FROM pa_cint_rate_info pcri

1415: ,pcri.interest_calculation_method interest_calc_method
1416: ,pcri.period_rate_code period_rate_code
1417: ,pcri.fin_plan_type_id fin_plan_type_id
1418: ,pirs.ind_rate_sch_id interest_sch_id
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