APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PER_ASSIGNMENTS_F

Line 488: per_assignments_f pa

484: to_char(nvl(ppos.actual_termination_date,g_effective_date),'YYYY/MM/DD')),'YYYY/MM/DD') effective_date,
485: null include_or_exclude
486: from pay_population_ranges ppr,
487: per_periods_of_service ppos,
488: per_assignments_f pa
489: where ppr.payroll_action_id = p_payroll_action_id
490: and ppr.chunk_number = p_chunk_number
491: and ppos.person_id = ppr.person_id
492: and ppos.business_group_id + 0 = g_business_group_id

Line 555: per_assignments_f pa,

551: to_char(nvl(ppos.actual_termination_date,g_effective_date),'YYYY/MM/DD')),'YYYY/MM/DD') effective_date,
552: hasa.include_or_exclude
553: from pay_population_ranges ppr,
554: per_periods_of_service ppos,
555: per_assignments_f pa,
556: hr_assignment_set_amendments hasa
557: where ppr.payroll_action_id = p_payroll_action_id
558: and ppr.chunk_number = p_chunk_number
559: and ppos.person_id = ppr.person_id

Line 628: per_assignments_f pa,

624: 'N',to_char(least(nvl(ppos.actual_termination_date,g_effective_date),g_effective_date),'YYYY/MM/DD'),
625: to_char(nvl(ppos.actual_termination_date,g_effective_date),'YYYY/MM/DD')),'YYYY/MM/DD') effective_date,
626: null include_or_exclude
627: from per_periods_of_service ppos,
628: per_assignments_f pa,
629: per_people_f pp
630: where ppos.person_id
631: between p_start_person_id and p_end_person_id
632: and ppos.business_group_id + 0 = g_business_group_id

Line 699: per_assignments_f pa,

695: 'N',to_char(least(nvl(ppos.actual_termination_date,g_effective_date),g_effective_date),'YYYY/MM/DD'),
696: to_char(nvl(ppos.actual_termination_date,g_effective_date),'YYYY/MM/DD')),'YYYY/MM/DD') effective_date,
697: hasa.include_or_exclude
698: from per_periods_of_service ppos,
699: per_assignments_f pa,
700: hr_assignment_set_amendments hasa,
701: per_people_f pp
702: where ppos.person_id
703: between p_start_person_id and p_end_person_id