APPS.HXC_TIMECARD_PROPERTIES dependencies on HXC_RECURRING_PERIODS

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

703: ,p_end_date in date
704: ,p_props in out nocopy hxc_timecard_prop_table_type) is
705:
706: cursor c_period_info
707: (p_recurring_period_id in HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE) is
708: select rp.period_type
709: ,rp.duration_in_days
710: ,substr(fnd_date.date_to_canonical(rp.start_date),1,50) start_date
711: from hxc_recurring_periods rp

Line 711: from hxc_recurring_periods rp

707: (p_recurring_period_id in HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE) is
708: select rp.period_type
709: ,rp.duration_in_days
710: ,substr(fnd_date.date_to_canonical(rp.start_date),1,50) start_date
711: from hxc_recurring_periods rp
712: where rp.recurring_period_id = p_recurring_period_id;
713:
714: cursor c_number_per_year
715: (p_type in per_time_periods.period_type%type) is

Line 721: l_duration_in_days HXC_RECURRING_PERIODS.DURATION_IN_DAYS%TYPE;

717: from per_time_period_types
718: where period_type = p_type;
719:
720: l_period_type PER_TIME_PERIOD_TYPES.period_type%TYPE;
721: l_duration_in_days HXC_RECURRING_PERIODS.DURATION_IN_DAYS%TYPE;
722: l_number_per_fiscal_year PER_TIME_PERIOD_TYPES.NUMBER_PER_FISCAL_YEAR%TYPE;
723: l_start_date VARCHAR2(50);
724:
725: BEGIN