DBA Data[Home] [Help]

APPS.HXC_HRP_BUS dependencies on PER_TIME_PERIOD_TYPES

Line 332: -- is valid within the per_time_period_types table, which is part of shared HR.

328: -- {Start Of Comments}
329: --
330: -- Description:
331: -- This chk procedure validates that the entered period type, if one exists,
332: -- is valid within the per_time_period_types table, which is part of shared HR.
333: -- This is used as a foreign key by the timecard screen and other OTC back end
334: -- processes to work out the period dates for timecards etc.
335: --
336: -- Pre Conditions:

Line 364: from PER_TIME_PERIOD_TYPES ptpt

360: cursor c_period_type(
361: p_period_type in HXC_RECURRING_PERIODS.PERIOD_TYPE%TYPE
362: ) is
363: select 'Y'
364: from PER_TIME_PERIOD_TYPES ptpt
365: where ptpt.period_type = p_period_type
366: and ptpt.period_type <> 'Bi-Month';
367:
368: l_proc varchar2(72) ;