APPS.PA_CAP_INT_PVT dependencies on PA_PROJECTS

Line 79: g_project_id pa_projects_all.project_id%TYPE;

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;

Line 1317: ln_proj_owning_org_id pa_projects_all.carrying_out_organization_id%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;

Line 1382: FROM pa_projects pp

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

Line 1437: FROM pa_projects pp

1433: AND pccm.ind_cost_code = picc.ind_cost_code
1434: -- AND pccm.ORGANIZATION_ID = pcri.org_id /* commented for bug 8625855 */
1435: AND EXISTS
1436: (SELECT 'X'
1437: FROM pa_projects pp
1438: WHERE pp.cint_rate_sch_id = pirs.ind_rate_sch_id
1439: AND pp.template_flag = 'N'
1440: AND pp.segment1 BETWEEN
1441: NVL(p_from_project_num,pp.segment1) AND NVL(p_to_project_num,pp.segment1))

Line 1460: ,pa_projects pp

1456: ,ppt.capital_cost_type_code cip_cost_type
1457: ,ppt.burden_amt_display_method burden_method
1458: ,ppt.total_burden_flag tot_burden_flag
1459: FROM pa_project_types ppt
1460: ,pa_projects pp
1461: WHERE TRUNC(g_period_end_date) <= TRUNC(NVL(pp.cint_stop_date,g_period_end_date))
1462: AND pp.cint_rate_sch_id IS NOT NULL
1463: AND NVL(pp.cint_eligible_flag,'Y') = 'Y'
1464: AND TRUNC(g_exp_item_date) BETWEEN

Line 3045: FROM pa_projects pp

3041: DELETE FROM pa_cint_source_details pcsd
3042: WHERE pcsd.run_period_end_date <= ld_period_end_date
3043: AND EXISTS
3044: (SELECT pp.project_id
3045: FROM pa_projects pp
3046: WHERE pp.segment1 BETWEEN
3047: NVL(p_from_project_num, pp.segment1) AND
3048: NVL(p_to_project_num, pp.segment1)
3049: AND pp.project_id = pcsd.project_id)