DBA Data[Home] [Help]

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;