DBA Data[Home] [Help]

APPS.PER_TIME_PERIOD_TYPES_PKG dependencies on PAY_CALENDARS

Line 64: from pay_calendars

60:
61: --
62: cursor csr_calendar is
63: select null
64: from pay_calendars
65: where upper(p_period_type) = upper(actual_period_type);
66: cursor csr_periods is
67: select null
68: from per_time_periods

Line 97: -- in the PAY_CALENDARS, PER_TIME_PERIOD_SETS, PER_COBRA_COV_ENROLLMENTS tables

93: having count(*) = 1);
94: --
95: --
96: -- Check there are no dependencies of the period type record
97: -- in the PAY_CALENDARS, PER_TIME_PERIOD_SETS, PER_COBRA_COV_ENROLLMENTS tables
98: -- and there is at least one record with fiscal year of 1 and 4
99: --
100: begin
101: