DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on PER_QUALIFICATIONS

Line 6344: from per_qualifications pqt

6340: ,p_qualification_type_id number
6341: ,p_title varchar2
6342: ,p_lf_evt_ocrd_dt date) is
6343: select null
6344: from per_qualifications pqt
6345: where pqt.person_id = p_person_id
6346: and pqt.qualification_type_id = p_qualification_type_id
6347: and nvl(pqt.title,'NULL' ) = NVL(p_title , 'NULL')
6348: and p_lf_evt_ocrd_dt between nvl(pqt.start_date , p_lf_evt_ocrd_dt)