DBA Data[Home] [Help]

APPS.HXC_TIMECARD_PROPERTIES dependencies on PER_TIME_PERIOD_TYPES

Line 690: from per_time_period_types

686:
687: cursor c_number_per_year
688: (p_type in per_time_periods.period_type%type) is
689: select number_per_fiscal_year
690: from per_time_period_types
691: where period_type = p_type;
692:
693: l_period_type PER_TIME_PERIOD_TYPES.period_type%TYPE;
694: l_duration_in_days HXC_RECURRING_PERIODS.DURATION_IN_DAYS%TYPE;

Line 693: l_period_type PER_TIME_PERIOD_TYPES.period_type%TYPE;

689: select number_per_fiscal_year
690: from per_time_period_types
691: where period_type = p_type;
692:
693: l_period_type PER_TIME_PERIOD_TYPES.period_type%TYPE;
694: l_duration_in_days HXC_RECURRING_PERIODS.DURATION_IN_DAYS%TYPE;
695: l_number_per_fiscal_year PER_TIME_PERIOD_TYPES.NUMBER_PER_FISCAL_YEAR%TYPE;
696: l_start_date VARCHAR2(50);
697:

Line 695: l_number_per_fiscal_year PER_TIME_PERIOD_TYPES.NUMBER_PER_FISCAL_YEAR%TYPE;

691: where period_type = p_type;
692:
693: l_period_type PER_TIME_PERIOD_TYPES.period_type%TYPE;
694: l_duration_in_days HXC_RECURRING_PERIODS.DURATION_IN_DAYS%TYPE;
695: l_number_per_fiscal_year PER_TIME_PERIOD_TYPES.NUMBER_PER_FISCAL_YEAR%TYPE;
696: l_start_date VARCHAR2(50);
697:
698: BEGIN
699: