APPS.PER_EVS_MAG_REPORT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 344: per_assignment_status_types past

340: per_all_assignments_f paf,
341: hr_soft_coding_keyflex hsck,
342: hr_all_organization_units hou,
343: hr_organization_information hoi,
344: per_assignment_status_types past
345: where paf.assignment_type = 'E'
346: and paf.primary_flag = 'Y'
347: and paf.effective_start_date <= to_date(g_end_date,'YYYY/MM/DD/')
348: and paf.effective_end_date >= to_date(g_start_date,'YYYY/MM/DD/')

Line 385: ,per_assignment_status_types past

381: per_people_f ppf
382: ,hr_soft_coding_keyflex hsck
383: ,per_assignments_f paf
384: ,per_periods_of_service pps
385: ,per_assignment_status_types past
386: where ppf.person_id = paf.person_id
387: and ppf.effective_start_date <= to_date(g_end_date,'YYYY/MM/DD/')
388: and ppf.effective_end_date >= to_date(g_start_date,'YYYY/MM/DD/')
389: and paf.effective_start_date <= to_date(g_end_date,'YYYY/MM/DD/')

Line 433: ,per_assignment_status_types past

429: ,per_all_assignments_f paf
430: ,hr_soft_coding_keyflex hsck
431: ,hr_organization_units hou
432: ,hr_organization_information hoi
433: ,per_assignment_status_types past
434: where paf.assignment_type = 'E'
435: and paf.primary_flag = 'Y'
436: and paf.effective_start_date <= to_date(g_end_date,'YYYY/MM/DD/')
437: and paf.effective_end_date >= to_date(g_start_date,'YYYY/MM/DD/')

Line 720: ,per_assignment_status_types past

716: per_people_f ppf
717: ,hr_soft_coding_keyflex hsck
718: ,per_assignments_f paf
719: ,per_periods_of_service pps
720: ,per_assignment_status_types past
721: Where
722: pps.person_id = ppf.person_id
723: and ppf.person_id = paf.person_id
724: and ppf.effective_start_date <= p_end_date