DBA Data[Home] [Help]

APPS.PON_CLM_CLO_UTIL_PKG dependencies on PER_ALL_PEOPLE_F

Line 1774: FROM PER_ALL_PEOPLE_F papf

1770: BEGIN
1771: IF(p_caller <>'PON') THEN
1772: SELECT papf.full_name
1773: INTO l_buyer_name
1774: FROM PER_ALL_PEOPLE_F papf
1775: where papf.person_id =l_buyer_id
1776: AND TRUNC(SYSDATE)
1777: BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE;
1778: ELSE

Line 1789: per_all_people_f papf

1785:
1786: select full_name
1787: into l_buyer_name
1788: from fnd_user usr,
1789: per_all_people_f papf
1790: where usr.user_name = l_ownerName
1791: AND usr.employee_id = papf.person_id
1792: AND TRUNC(SYSDATE)
1793: BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE;