[Home] [Help]
75:
76:
77: -- Globally used variables
78: g_gl_period gl_period_statuses.period_name%TYPE;
79: g_project_id pa_projects_all.project_id%TYPE;
80: g_rate_name pa_ind_cost_codes.ind_cost_code%TYPE;
81: g_period_end_date gl_period_statuses.end_date%TYPE;
82: g_period_start_date gl_period_statuses.end_date%TYPE;
83: g_exp_item_date gl_period_statuses.end_date%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;
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;
1378: --)
1379: /* End Bug fix :3028240
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
1430: AND pccm.ind_cost_code = picc.ind_cost_code
1431: AND pccm.ORGANIZATION_ID = pcri.org_id
1432: AND EXISTS
1433: (SELECT 'X'
1434: FROM pa_projects pp
1435: WHERE pp.cint_rate_sch_id = pirs.ind_rate_sch_id
1436: AND pp.template_flag = 'N'
1437: AND pp.segment1 BETWEEN
1438: NVL(p_from_project_num,pp.segment1) AND NVL(p_to_project_num,pp.segment1))
1453: ,ppt.capital_cost_type_code cip_cost_type
1454: ,ppt.burden_amt_display_method burden_method
1455: ,ppt.total_burden_flag tot_burden_flag
1456: FROM pa_project_types ppt
1457: ,pa_projects pp
1458: WHERE TRUNC(g_period_end_date) <= TRUNC(NVL(pp.cint_stop_date,g_period_end_date))
1459: AND pp.cint_rate_sch_id IS NOT NULL
1460: AND NVL(pp.cint_eligible_flag,'Y') = 'Y'
1461: AND TRUNC(g_exp_item_date) BETWEEN
3038: DELETE FROM pa_cint_source_details pcsd
3039: WHERE pcsd.run_period_end_date <= ld_period_end_date
3040: AND EXISTS
3041: (SELECT pp.project_id
3042: FROM pa_projects pp
3043: WHERE pp.segment1 BETWEEN
3044: NVL(p_from_project_num, pp.segment1) AND
3045: NVL(p_to_project_num, pp.segment1)
3046: AND pp.project_id = pcsd.project_id)