DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on PER_QUALIFICATIONS

Line 6401: from per_qualifications pqt

6397: ,p_qualification_type_id number
6398: ,p_title varchar2
6399: ,p_lf_evt_ocrd_dt date) is
6400: select null
6401: from per_qualifications pqt
6402: where pqt.person_id = p_person_id
6403: and pqt.qualification_type_id = p_qualification_type_id
6404: and nvl(pqt.title,'NULL' ) = NVL(p_title , 'NULL')
6405: and p_lf_evt_ocrd_dt between nvl(pqt.start_date , p_lf_evt_ocrd_dt)