APPS.PA_CONTROL_ITEMS_UTILS dependencies on PER_ALL_PEOPLE_F

Line 1083: FROM per_all_people_f

1079:
1080: IF l_emp_id>0 THEN
1081: SELECT full_name
1082: INTO G_party_name
1083: FROM per_all_people_f
1084: WHERE person_id = l_emp_id
1085: and trunc(sysdate) between trunc(EFFECTIVE_START_DATE) and trunc(EFFECTIVE_END_DATE)
1086: and (CURRENT_EMPLOYEE_FLAG = 'Y' or CURRENT_NPW_FLAG = 'Y'); /* Added OR condition for bug 7132968 */
1087: ELSIF (l_party_id > 0) THEN

Line 1135: FROM per_all_people_f

1131:
1132: IF l_emp_id>0 THEN
1133: SELECT party_id
1134: INTO G_party_id
1135: FROM per_all_people_f
1136: WHERE person_id = l_emp_id
1137: AND ROWNUM=1;
1138: END IF;
1139: