DBA Data[Home] [Help]

APPS.BEN_CAGR_CHECK_ELIGIBILITY dependencies on PER_QUALIFICATIONS

Line 1149: from per_qualifications qua

1145: )
1146: is
1147: select qua.TITLE,
1148: qua.QUALIFICATION_TYPE_ID
1149: from per_qualifications qua
1150: where qua.person_id = c_per_id
1151: and c_eff_dt between nvl(start_date,hr_general.start_of_time)
1152: and nvl(end_date,hr_general.end_of_time)
1153: order by nvl(start_date,hr_general.start_of_time) desc ,qualification_id desc ;