DBA Data[Home] [Help]

APPS.PER_TIME_PERIOD_TYPES_PKG dependencies on PER_COBRA_COV_ENROLLMENTS

Line 72: from per_cobra_cov_enrollments

68: from per_time_periods
69: where upper(p_period_type) = upper(period_type);
70: cursor csr_cobra is
71: select null
72: from per_cobra_cov_enrollments
73: where upper(p_period_type) = upper(period_type);
74: cursor csr_year is
75: select null
76: from per_time_period_types

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: