DBA Data[Home] [Help]

APPS.OKC_REP_QA_CHECK_PVT dependencies on PER_WORKFORCE_V

Line 613: per_workforce_v p,

609:
610:
611: CURSOR cur_int_user(p_contact_id IN NUMBER) is
612: SELECT f.user_name,p.full_name contact_name from
613: per_workforce_v p,
614: fnd_user f
615: WHERE f.employee_id(+)=p.person_id and
616: p.person_id=p_contact_id;
617:

Line 1260: -- Bug 6598261.Changed per_all_workforce_v to per_workforce_v.

1256: WHERE vendor_contact_id=p_contact_id;
1257:
1258: vendor_contact_rec vendor_contact_csr%ROWTYPE;
1259:
1260: -- Bug 6598261.Changed per_all_workforce_v to per_workforce_v.
1261:
1262: CURSOR employee_contact_csr IS
1263: SELECT full_name contact_name
1264: FROM per_workforce_v

Line 1264: FROM per_workforce_v

1260: -- Bug 6598261.Changed per_all_workforce_v to per_workforce_v.
1261:
1262: CURSOR employee_contact_csr IS
1263: SELECT full_name contact_name
1264: FROM per_workforce_v
1265: WHERE person_id = p_contact_id;
1266:
1267: CURSOR employee_name_csr IS
1268: SELECT per.full_name contact_name