130: AND p_date BETWEEN ppf.effective_start_date and ppf.effective_end_date
131: AND p_date BETWEEN ppf2.effective_start_date and ppf2.effective_end_date
132: AND ppf2.person_id = empl.person_id
133: AND p_date BETWEEN nvl(empl.START_DATE,trunc(SYSDATE)) 134: and(nvl(empl.END_DATE,hr_api.g_eot)); 135:
136: BEGIN
137: -- MAIN FUNCTION LOGIC
138: