APPS.PA_BUDGET_CORE dependencies on PA_PROJECTS_ALL

Line 390: pa_projects_all p,

386: into x_project_id, x_budget_type_code, x_resource_list_id,
387: x_project_type_class_code,x_time_phased_type_code,
388: x_entry_level_code, x_pm_product_code
389: from pa_project_types_all t,
390: pa_projects_all p,
391: pa_budget_versions v,
392: pa_budget_entry_methods b
393: where v.budget_version_id = x_draft_version_id
394: and v.project_id = p.project_id

Line 803: from pa_projects_all

799: -- Added nvl in the below select query for the bug 11891595
800: select start_date,nvl(completion_date,PA_BUDGET_CHECK_PVT.Get_project_end_date) -- Changed for the bug 13344742
801: into v_project_start_date,
802: v_project_completion_date
803: from pa_projects_all
804: where project_id = x_project_id;
805:
806: if (v_project_start_date is null ) or (v_project_completion_date
807: is null) then

Line 831: from pa_projects_all

827: print_msg(x_err_stage);
828: select start_date,completion_date
829: into v_project_start_date,
830: v_project_completion_date
831: from pa_projects_all
832: where project_id = x_project_id;
833:
834: for bl_rec in (select start_date,
835: completion_date ,

Line 1598: from pa_projects_all a,pa_budget_versions b /*Modified for 6320792 */

1594: || to_char(x_src_version_id) || '>';
1595:
1596: select start_date
1597: into g_project_start_date
1598: from pa_projects_all a,pa_budget_versions b /*Modified for 6320792 */
1599: where b.budget_version_id = x_src_version_id
1600: and a.project_id = b.project_id;
1601:
1602: savepoint before_copy;

Line 2064: l_project_id pa_projects_all.project_id%TYPE;

2060: TYPE period_info_tab IS TABLE OF NUMBER INDEX BY VARCHAR2(60);
2061:
2062: l_period_info_tbl period_info_tab;
2063:
2064: l_project_id pa_projects_all.project_id%TYPE;
2065: l_min_start_date DATE;
2066:
2067: -- end bug 4914055
2068:

Line 2229: FROM pa_projects_all p /*Modified for bug 6320792 */

2225: if ( (x_time_phased_type_code = 'G')
2226: or (x_time_phased_type_code = 'P')) then
2227: SELECT p.start_date
2228: INTO l_min_start_date
2229: FROM pa_projects_all p /*Modified for bug 6320792 */
2230: WHERE p.project_id = l_project_id;
2231:
2232: IF l_min_start_date IS NULL THEN
2233: SELECt min(t.start_date)