APPS.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on HXC_RECURRING_PERIODS

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

765: (p_resource_id in number
766: ,p_period_returns out nocopy varchar2) is
767:
768: cursor c_period_info
769: (p_recurring_period_id in HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE) is
770: select rp.period_type
771: ,rp.duration_in_days
772: ,p.number_per_fiscal_year
773: ,substr(fnd_date.date_to_canonical(rp.start_date),1,50) start_date

Line 774: from hxc_recurring_periods rp

770: select rp.period_type
771: ,rp.duration_in_days
772: ,p.number_per_fiscal_year
773: ,substr(fnd_date.date_to_canonical(rp.start_date),1,50) start_date
774: from hxc_recurring_periods rp
775: ,per_time_period_types p
776: where p.period_type (+) = rp.period_type
777: and rp.recurring_period_id = p_recurring_period_id;
778:

Line 780: l_duration_in_days HXC_RECURRING_PERIODS.DURATION_IN_DAYS%TYPE;

776: where p.period_type (+) = rp.period_type
777: and rp.recurring_period_id = p_recurring_period_id;
778:
779: l_period_type PER_TIME_PERIOD_TYPES.period_type%TYPE;
780: l_duration_in_days HXC_RECURRING_PERIODS.DURATION_IN_DAYS%TYPE;
781: l_number_per_fiscal_year PER_TIME_PERIOD_TYPES.NUMBER_PER_FISCAL_YEAR%TYPE;
782: l_start_date VARCHAR2(50);
783: l_recurring_period_id HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE;
784:

Line 783: l_recurring_period_id HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE;

779: l_period_type PER_TIME_PERIOD_TYPES.period_type%TYPE;
780: l_duration_in_days HXC_RECURRING_PERIODS.DURATION_IN_DAYS%TYPE;
781: l_number_per_fiscal_year PER_TIME_PERIOD_TYPES.NUMBER_PER_FISCAL_YEAR%TYPE;
782: l_start_date VARCHAR2(50);
783: l_recurring_period_id HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE;
784:
785: l_v_duration_in_days VARCHAR2(2000);
786: l_v_number_per_fiscal_year VARCHAR2(2000);
787: l_v_period_type VARCHAR2(2000);