APPS.PNP_UTIL_FUNC dependencies on PA_PROJECTS

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

3324: --
3325: -- REFERENCE :
3326: -- HISTORY :
3327: -- 25-MAY-00 Daniel Thota o Created
3328: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced PA_PROJECTS
3329: -- with _ALL table.
3330: +============================================================================*/
3331: FUNCTION GET_EMP_PR_DATA (p_projectId IN NUMBER) RETURN EMP_PR_DATA_REC IS
3332: l_emp_pr_data EMP_PR_DATA_REC ;

Line 3339: FROM PA_PROJECTS_ALL pa,

3335:
3336: SELECT pa.segment1,
3337: hou.name
3338: INTO l_emp_pr_data
3339: FROM PA_PROJECTS_ALL pa,
3340: HR_ORGANIZATION_UNITS hou
3341: WHERE pa.project_id = p_projectId
3342: AND hou.organization_id = pa.carrying_out_organization_id;
3343:

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

5626: -- RETURNS : Project Name
5627: -- REFERENCE :
5628: -- HISTORY :
5629: -- 23-MAY-01 Mrinal Misra o Created
5630: -- 23-APR-04 ftanudja o Changed pa_projects_expend_v to pa_projects
5631: -- for performance. #3239094.
5632: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced pa_projects
5633: -- with _ALL table.
5634: +===========================================================================*/

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

5628: -- HISTORY :
5629: -- 23-MAY-01 Mrinal Misra o Created
5630: -- 23-APR-04 ftanudja o Changed pa_projects_expend_v to pa_projects
5631: -- for performance. #3239094.
5632: -- 15-JUN-05 piagrawa o Bug 4307795 - Replaced pa_projects
5633: -- with _ALL table.
5634: +===========================================================================*/
5635: FUNCTION Get_Ap_Project_Name (p_project_id IN NUMBER) RETURN VARCHAR2 IS
5636:

Line 5637: l_project_name pa_projects.name%type;

5633: -- with _ALL table.
5634: +===========================================================================*/
5635: FUNCTION Get_Ap_Project_Name (p_project_id IN NUMBER) RETURN VARCHAR2 IS
5636:
5637: l_project_name pa_projects.name%type;
5638:
5639: BEGIN
5640:
5641: SELECT name

Line 5643: FROM pa_projects_all

5639: BEGIN
5640:
5641: SELECT name
5642: INTO l_project_name
5643: FROM pa_projects_all
5644: WHERE project_id = p_project_id;
5645:
5646: RETURN(l_project_name);
5647: