APPS.PA_DELIVERABLE_UTILS dependencies on PER_ALL_PEOPLE_F

Line 1805: ,x_owner_id OUT NOCOPY PER_ALL_PEOPLE_F.PERSON_ID%TYPE --File.Sql.39 bug 4440895

1801: PROCEDURE GET_DEFAULT_DLVR_OWNER
1802: (
1803: p_project_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1804: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1805: ,x_owner_id OUT NOCOPY PER_ALL_PEOPLE_F.PERSON_ID%TYPE --File.Sql.39 bug 4440895
1806: ,x_owner_name OUT NOCOPY PER_ALL_PEOPLE_F.FULL_NAME%TYPE --File.Sql.39 bug 4440895
1807: )
1808: IS
1809:

Line 1806: ,x_owner_name OUT NOCOPY PER_ALL_PEOPLE_F.FULL_NAME%TYPE --File.Sql.39 bug 4440895

1802: (
1803: p_project_id IN PA_PROJ_ELEMENTS.PROJ_ELEMENT_ID%TYPE
1804: ,p_task_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1805: ,x_owner_id OUT NOCOPY PER_ALL_PEOPLE_F.PERSON_ID%TYPE --File.Sql.39 bug 4440895
1806: ,x_owner_name OUT NOCOPY PER_ALL_PEOPLE_F.FULL_NAME%TYPE --File.Sql.39 bug 4440895
1807: )
1808: IS
1809:
1810: CURSOR l_owner_info_csr

Line 1817: PER_ALL_PEOPLE_F PPF,

1813: PPF.PERSON_ID
1814: ,PPF.FULL_NAME
1815: FROM
1816: PA_PROJ_ELEMENTS PPE,
1817: PER_ALL_PEOPLE_F PPF,
1818: PA_PROJ_ELEMENT_VERSIONS PEV
1819: WHERE
1820: PEV.ELEMENT_VERSION_ID = p_task_ver_id
1821: AND PEV.OBJECT_TYPE = 'PA_TASKS'

Line 1988: ,x_owner_id OUT NOCOPY PER_ALL_PEOPLE_F.PERSON_ID%TYPE --File.Sql.39 bug 4440895

1984:
1985: PROCEDURE GET_DEFAULT_ACTION_OWNER
1986: (
1987: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1988: ,x_owner_id OUT NOCOPY PER_ALL_PEOPLE_F.PERSON_ID%TYPE --File.Sql.39 bug 4440895
1989: ,x_owner_name OUT NOCOPY PER_ALL_PEOPLE_F.FULL_NAME%TYPE --File.Sql.39 bug 4440895
1990: )
1991: IS
1992:

Line 1989: ,x_owner_name OUT NOCOPY PER_ALL_PEOPLE_F.FULL_NAME%TYPE --File.Sql.39 bug 4440895

1985: PROCEDURE GET_DEFAULT_ACTION_OWNER
1986: (
1987: p_dlvr_ver_id IN PA_PROJ_ELEMENT_VERSIONS.ELEMENT_VERSION_ID%TYPE
1988: ,x_owner_id OUT NOCOPY PER_ALL_PEOPLE_F.PERSON_ID%TYPE --File.Sql.39 bug 4440895
1989: ,x_owner_name OUT NOCOPY PER_ALL_PEOPLE_F.FULL_NAME%TYPE --File.Sql.39 bug 4440895
1990: )
1991: IS
1992:
1993: CURSOR l_owner_info_csr

Line 2001: ,PER_ALL_PEOPLE_F PPF

1997: ,PPF.FULL_NAME
1998: FROM
1999: PA_PROJ_ELEMENT_VERSIONS PEV
2000: ,PA_PROJ_ELEMENTS PPE
2001: ,PER_ALL_PEOPLE_F PPF
2002: WHERE
2003: PEV.ELEMENT_VERSION_ID = p_dlvr_ver_id
2004: AND PPE.OBJECT_TYPE = 'PA_DELIVERABLES'
2005: AND PPE.PROJ_ELEMENT_ID = PEV.PROJ_ELEMENT_ID