APPS.PER_EVS_MAG_REPORT dependencies on PER_PERIODS_OF_SERVICE

Line 286: ,per_periods_of_service pps

282: from
283: per_people_f ppf
284: ,hr_soft_coding_keyflex hsck
285: ,per_assignments_f paf
286: ,per_periods_of_service pps
287: where ppf.person_id = pps.person_id
288: and pps.date_start
289: between to_date(g_start_date,'YYYY/MM/DD/')
290: and to_date(g_end_date,'YYYY/MM/DD/')

Line 384: ,per_periods_of_service pps

380: from
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/')

Line 481: ,per_periods_of_service pps

477: from
478: per_people_f ppf
479: ,hr_soft_coding_keyflex hsck
480: ,per_assignments_f paf
481: ,per_periods_of_service pps
482: ,per_person_type_usages_f ptu
483: ,per_person_types ppt
484: where ppf.person_id = pps.person_id
485: and pps.actual_termination_date is not NULL

Line 719: ,per_periods_of_service pps

715: From
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

Line 764: ,per_periods_of_service pps

760: From
761: per_people_f ppf
762: ,hr_soft_coding_keyflex hsck
763: ,per_assignments_f paf
764: ,per_periods_of_service pps
765: Where
766: ppf.person_id = pps.person_id
767: and pps.date_start between
768: p_start_date and p_end_date

Line 803: ,per_periods_of_service pps

799: From
800: per_people_f ppf
801: ,hr_soft_coding_keyflex hsck
802: ,per_assignments_f paf
803: ,per_periods_of_service pps
804: ,per_person_type_usages_f ptu
805: ,per_person_types ppt
806: Where
807: ppf.person_id = pps.person_id

Line 857: ,per_periods_of_service pps

853: From
854: per_people_f ppf
855: ,hr_soft_coding_keyflex hsck
856: ,per_assignments_f paf
857: ,per_periods_of_service pps
858: ,per_person_type_usages_f ptu
859: ,per_person_types ppt
860: Where
861: ppf.person_id = pps.person_id

Line 893: ,per_periods_of_service pps2

889: And ppf.business_group_id +0 = p_business_group_id
890: and exists
891: (select null
892: from per_people_f ppf2
893: ,per_periods_of_service pps2
894: where
895: ppf2.person_id = ppf.person_id
896: and ppf2.current_employee_flag = 'Y'
897: and pps2.person_id = ppf2.person_id