DBA Data[Home] [Help]

APPS.PAY_US_TAX_INTERNAL dependencies on PER_PERIODS_OF_SERVICE

Line 2732: from per_periods_of_service pos

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

Line 2736: from per_periods_of_service pos2

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