APPS.PA_BUDGET_CORE dependencies on PA_PROJECTS_ALL

Line 388: pa_projects_all p,

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

Line 799: from pa_projects_all

795: print_msg(x_err_stage);
796: select start_date,completion_date
797: into v_project_start_date,
798: v_project_completion_date
799: from pa_projects_all
800: where project_id = x_project_id;
801:
802: if (v_project_start_date is null ) or (v_project_completion_date
803: is null) then

Line 827: from pa_projects_all

823: print_msg(x_err_stage);
824: select start_date,completion_date
825: into v_project_start_date,
826: v_project_completion_date
827: from pa_projects_all
828: where project_id = x_project_id;
829:
830: for bl_rec in (select start_date,
831: completion_date ,

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

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

Line 2060: l_project_id pa_projects_all.project_id%TYPE;

2056: TYPE period_info_tab IS TABLE OF NUMBER INDEX BY VARCHAR2(60);
2057:
2058: l_period_info_tbl period_info_tab;
2059:
2060: l_project_id pa_projects_all.project_id%TYPE;
2061: l_min_start_date DATE;
2062:
2063: -- end bug 4914055
2064:

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

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