APPS.PA_CAP_INT_PVT dependencies on PA_IND_RATE_SCH_REVISIONS

Line 630: FROM pa_ind_rate_sch_revisions pirsr

626: IS
627: BEGIN
628: SELECT ind_rate_sch_revision_id
629: INTO x_sched_version_id
630: FROM pa_ind_rate_sch_revisions pirsr
631: WHERE TRUNC(p_test_date) BETWEEN
632: TRUNC(pirsr.start_date_active) AND TRUNC(NVL(pirsr.end_date_active, p_test_date))
633: AND pirsr.compiled_flag = 'Y'
634: AND pirsr.ind_rate_sch_id = p_int_sch_id;

Line 1318: ln_sched_version_id pa_ind_rate_sch_revisions.ind_rate_sch_revision_id%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;
1320: lv_burden_method pa_project_types_all.burden_amt_display_method%TYPE;
1321: lv_tot_burden_flag pa_project_types_all.total_burden_flag%TYPE;
1322:

Line 1384: ,pa_ind_rate_sch_revisions pirsv

1380: AND EXISTS
1381: (SELECT 'X'
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'

Line 1422: ,pa_ind_rate_sch_revisions pirsv

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
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)