APPS.HXC_TK_GRP_QUERY_CRITERIA_API dependencies on HXC_RECURRING_PERIODS

Line 864: l_tc_period hxc_recurring_periods.name%TYPE;

860: -- ----------------------------------------------------------------------------
861: FUNCTION get_tc_period ( p_resource_id number )
862: RETURN varchar2 IS
863:
864: l_tc_period hxc_recurring_periods.name%TYPE;
865: l_pref_tab hxc_preference_evaluation.t_pref_table;
866: l_recurring_period_id hxc_pref_hierarchies.attribute1%TYPE;
867:
868: l_session_date DATE;

Line 872: FROM hxc_recurring_periods rp

868: l_session_date DATE;
869:
870: CURSOR csr_get_tc_period ( p_rp_id VARCHAR2 ) IS
871: SELECT rp.name
872: FROM hxc_recurring_periods rp
873: WHERE rp.recurring_period_id = TO_NUMBER(p_rp_id);
874:
875: CURSOR csr_get_effective_date IS
876: SELECT effective_date

Line 996: FROM hxc_recurring_periods rp

992:
993: CURSOR csr_get_tc_period_type ( p_rp_id VARCHAR2 ) IS
994: SELECT rp.period_type
995: , rp.duration_in_days
996: FROM hxc_recurring_periods rp
997: WHERE rp.recurring_period_id = TO_NUMBER(p_rp_id);
998:
999: l_period_rec csr_get_tc_period_type%ROWTYPE;
1000: