APPS.PA_CONTROL_ITEMS_UTILS dependencies on PER_ALL_PEOPLE_F

Line 1167: FROM per_all_people_f

1163: WHERE party_id = l_party_id;
1164: ELSIF l_emp_id>0 THEN
1165: SELECT full_name
1166: INTO G_party_name
1167: FROM per_all_people_f
1168: WHERE person_id = l_emp_id
1169: and trunc(sysdate) between trunc(EFFECTIVE_START_DATE) and trunc(EFFECTIVE_END_DATE)
1170: and (CURRENT_EMPLOYEE_FLAG = 'Y' or CURRENT_NPW_FLAG = 'Y'); /* Added OR condition for bug 7132968 */
1171: END IF;

Line 1214: FROM per_all_people_f

1210:
1211: IF l_emp_id>0 THEN
1212: SELECT party_id
1213: INTO G_party_id
1214: FROM per_all_people_f
1215: WHERE person_id = l_emp_id
1216: AND ROWNUM=1;
1217: END IF;
1218: