APPS.HXC_APPROVAL_WF_PKG dependencies on HXC_RECURRING_PERIODS

Line 1436: RETURN HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE

1432: ,p_day_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1433: ,p_timecard_start_time in HXC_TIME_BUILDING_BLOCKS.START_TIME%TYPE
1434: ,p_timecard_stop_time in HXC_TIME_BUILDING_BLOCKS.STOP_TIME%TYPE
1435: )
1436: RETURN HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE
1437: IS
1438:
1439: cursor csr_get_app_rec_period(
1440: p_time_recipient_id number,

Line 1451: l_recurring_period_id HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE;

1447: and hapc.approval_period_set_id = haps.approval_period_set_id
1448: and hapc.time_recipient_id = p_time_recipient_id;
1449:
1450: l_app_periods HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE;
1451: l_recurring_period_id HXC_RECURRING_PERIODS.RECURRING_PERIOD_ID%TYPE;
1452: l_day_number NUMBER;
1453: l_day_count NUMBER;
1454: l_pref_found BOOLEAN;
1455: l_day_check DATE;

Line 1577: from hxc_recurring_periods hrp

1573: cursor csr_get_rec_period_info(p_recurring_period_id number) is
1574: select hrp.start_date,
1575: hrp.period_type,
1576: hrp.duration_in_days
1577: from hxc_recurring_periods hrp
1578: where hrp.recurring_period_id = p_recurring_period_id;
1579:
1580: BEGIN
1581: