DBA Data[Home] [Help]

APPS.PER_JP_EMPDET_ARCHIVE_PKG dependencies on PAY_POPULATION_RANGES

Line 486: from pay_population_ranges ppr,

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

Line 553: from pay_population_ranges ppr,

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