APPS.PSP_GENERAL dependencies on PA_PROJECTS_ALL

Line 809: FROM pa_projects_all

805: --insert_into_psp_stout( 'starting poeta_effective_date');
806:
807: SELECT nvl(completion_date,p_payroll_end_date)
808: INTO l_project_end_date
809: FROM pa_projects_all
810: WHERE project_id = p_project_id;
811:
812: SELECT nvl(end_date_active,p_payroll_end_date)
813: INTO l_award_end_date

Line 855: FROM pa_projects_all

851: --insert_into_psp_stout( 'starting poeta_effective_date');
852:
853: SELECT nvl(completion_date,p_payroll_end_date)
854: INTO l_project_end_date
855: FROM pa_projects_all
856: WHERE project_id = p_project_id;
857:
858:
859: SELECT nvl(completion_date,p_payroll_end_date)

Line 1369: FROM pa_projects_all

1365: -- Introduced the following for bug fix 2635110
1366: FUNCTION get_project_number (p_project_id IN NUMBER) RETURN VARCHAR2 IS
1367: CURSOR project_number_cur IS
1368: SELECT segment1
1369: FROM pa_projects_all
1370: WHERE project_id = p_project_id;
1371:
1372: l_project_number VARCHAR2(200);
1373:

Line 1827: FROM pa_projects_all ppa,

1823:
1824: FUNCTION get_sponsored_flag (p_project_id IN NUMBER) RETURN VARCHAR2 IS
1825: CURSOR sponsored_flag_cur IS
1826: SELECT sponsored_flag
1827: FROM pa_projects_all ppa,
1828: gms_project_types gpt -- Changed from gms_project_types_all for P1 bug 4078481
1829: WHERE gpt.project_type = ppa.project_type
1830: AND ppa.project_type <> 'AWARD_PROJECT'
1831: AND ppa.project_id = p_project_id;

Line 2901: FROM pa_projects_all

2897: -- get the org_id for the project..
2898: BEGIN
2899: SELECT org_id
2900: INTO l_org_id
2901: FROM pa_projects_all
2902: WHERE project_id = p_project_Id;
2903: EXCEPTION
2904: WHEN NO_DATA_FOUND THEN
2905: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;