DBA Data[Home] [Help]

APPS.PAY_US_TAX_INTERNAL dependencies on PER_PERIODS_OF_SERVICE

Line 2730: from per_periods_of_service pos

2726:
2727: --
2728: cursor csr_latest_pos is
2729: select final_process_date
2730: from per_periods_of_service pos
2731: where pos.person_id = p_person_id
2732: and pos.date_start =
2733: (select max(date_start)
2734: from per_periods_of_service pos2

Line 2734: from per_periods_of_service pos2

2730: from per_periods_of_service pos
2731: where pos.person_id = p_person_id
2732: and pos.date_start =
2733: (select max(date_start)
2734: from per_periods_of_service pos2
2735: where pos2.person_id = pos.person_id
2736: and date_start <= p_effective_date);
2737: --
2738: l_proc varchar2(100) := g_package||'validate_us_address';