APPS.HXC_DEPOSIT_WRAPPER_UTILITIES dependencies on PER_TIME_PERIOD_TYPES

Line 775: ,per_time_period_types p

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:
779: l_period_type PER_TIME_PERIOD_TYPES.period_type%TYPE;

Line 779: l_period_type PER_TIME_PERIOD_TYPES.period_type%TYPE;

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:
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;

Line 781: l_number_per_fiscal_year PER_TIME_PERIOD_TYPES.NUMBER_PER_FISCAL_YEAR%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:
785: l_v_duration_in_days VARCHAR2(2000);