APPS.PNP_UTIL_FUNC dependencies on PA_PROJECTS

Line 3486: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced PA_PROJECTS

3482: --
3483: -- REFERENCE :
3484: -- HISTORY :
3485: -- 25-MAY-00 Daniel Thota o Created
3486: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced PA_PROJECTS
3487: -- with _ALL table.
3488: +============================================================================*/
3489: FUNCTION GET_EMP_PR_DATA (p_projectId IN NUMBER) RETURN EMP_PR_DATA_REC IS
3490: l_emp_pr_data EMP_PR_DATA_REC ;

Line 3497: FROM PA_PROJECTS_ALL pa,

3493:
3494: SELECT pa.segment1,
3495: hou.name
3496: INTO l_emp_pr_data
3497: FROM PA_PROJECTS_ALL pa,
3498: HR_ORGANIZATION_UNITS hou
3499: WHERE pa.project_id = p_projectId
3500: AND hou.organization_id = pa.carrying_out_organization_id;
3501:

Line 5788: -- 23-APR-04 ftanudja o Changed pa_projects_expend_v to pa_projects

5784: -- RETURNS : Project Name
5785: -- REFERENCE :
5786: -- HISTORY :
5787: -- 23-MAY-01 Mrinal Misra o Created
5788: -- 23-APR-04 ftanudja o Changed pa_projects_expend_v to pa_projects
5789: -- for performance. #3239094.
5790: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced pa_projects
5791: -- with _ALL table.
5792: +===========================================================================*/

Line 5790: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced pa_projects

5786: -- HISTORY :
5787: -- 23-MAY-01 Mrinal Misra o Created
5788: -- 23-APR-04 ftanudja o Changed pa_projects_expend_v to pa_projects
5789: -- for performance. #3239094.
5790: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced pa_projects
5791: -- with _ALL table.
5792: +===========================================================================*/
5793: FUNCTION Get_Ap_Project_Name (p_project_id IN NUMBER) RETURN VARCHAR2 IS
5794:

Line 5795: l_project_name pa_projects.name%type;

5791: -- with _ALL table.
5792: +===========================================================================*/
5793: FUNCTION Get_Ap_Project_Name (p_project_id IN NUMBER) RETURN VARCHAR2 IS
5794:
5795: l_project_name pa_projects.name%type;
5796:
5797: BEGIN
5798:
5799: SELECT name

Line 5801: FROM pa_projects_all

5797: BEGIN
5798:
5799: SELECT name
5800: INTO l_project_name
5801: FROM pa_projects_all
5802: WHERE project_id = p_project_id;
5803:
5804: RETURN(l_project_name);
5805: