APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PER_PERIODS_OF_SERVICE

Line 435: per_periods_of_service ppos

431: p_sqlstr :=
432: 'select distinct ppos.person_id
433: from pay_payroll_actions ppa,
434: per_people_f pp,
435: per_periods_of_service ppos
436: where ppa.payroll_action_id = :payroll_action_id
437: and pp.business_group_id = ppa.business_group_id + 0
438: and ppos.person_id = pp.person_id
439: and ppos.business_group_id + 0 = pp.business_group_id

Line 487: per_periods_of_service ppos,

483: 'N',to_char(least(nvl(ppos.actual_termination_date,g_effective_date),g_effective_date),'YYYY/MM/DD'),
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

Line 554: per_periods_of_service ppos,

550: 'N',to_char(least(nvl(ppos.actual_termination_date,g_effective_date),g_effective_date),'YYYY/MM/DD'),
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

Line 627: from per_periods_of_service ppos,

623: to_date(decode(nvl(g_inc_term_flag,'N'),
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

Line 698: from per_periods_of_service ppos,

694: to_date(decode(nvl(g_inc_term_flag,'N'),
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

Line 1516: per_periods_of_service ppos,

1512: to_date(decode(nvl(g_inc_term_flag,'N'),
1513: 'N',to_char(least(nvl(ppos.final_process_date,g_effective_date),g_effective_date),'YYYY/MM/DD'),
1514: to_char(nvl(ppos.final_process_date,g_effective_date),'YYYY/MM/DD')),'YYYY/MM/DD') effective_date_proc
1515: from per_all_assignments_f pa,
1516: per_periods_of_service ppos,
1517: per_all_people_f pp
1518: where pa.assignment_id = p_assignment_id
1519: and ppos.period_of_service_id = pa.period_of_service_id
1520: and to_date(decode(nvl(g_inc_term_flag,'N'),

Line 1834: from per_periods_of_service ppos,

1830: pa.organization_id,
1831: hou.name organization_name,
1832: pa.job_id,
1833: pj.name job_name
1834: from per_periods_of_service ppos,
1835: per_all_assignments_f pa,
1836: hr_organization_units hou,
1837: per_jobs_vl pj
1838: where ppos.person_id = l_person_id