APPS.PA_PAY_VALIDATE dependencies on PER_ALL_PEOPLE_F
Line 322: from per_all_people_f
318:
319: /* Validation to check whether the person is active or not */
320:
321: select count(1) into l_value_exists 322: from per_all_people_f 323: where person_id = Details_rec.PERSON_ID
324: and nvl(current_employee_flag, 'N') = 'Y'
325: and effective_start_date <= Hdr_rec.time_period_start_date
326: and nvl(effective_end_date,Hdr_rec.time_period_end_date+1) >= Hdr_rec.time_period_end_date;