DBA Data[Home] [Help]

APPS.HXC_TIMECARD_PROPERTIES dependencies on HXC_RECURRING_PERIODS

Line 680: (p_recurring_period_id in HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE) is

676: ,p_end_date in date
677: ,p_props in out nocopy hxc_timecard_prop_table_type) is
678:
679: cursor c_period_info
680: (p_recurring_period_id in HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE) is
681: select rp.period_type
682: ,rp.duration_in_days
683: ,substr(fnd_date.date_to_canonical(rp.start_date),1,50) start_date
684: from hxc_recurring_periods rp

Line 684: from hxc_recurring_periods rp

680: (p_recurring_period_id in HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE) is
681: select rp.period_type
682: ,rp.duration_in_days
683: ,substr(fnd_date.date_to_canonical(rp.start_date),1,50) start_date
684: from hxc_recurring_periods rp
685: where rp.recurring_period_id = p_recurring_period_id;
686:
687: cursor c_number_per_year
688: (p_type in per_time_periods.period_type%type) is

Line 694: l_duration_in_days HXC_RECURRING_PERIODS.DURATION_IN_DAYS%TYPE;

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:
698: BEGIN