DBA Data[Home] [Help]

APPS.HXC_APC_UPLOAD_PKG dependencies on HXC_APPROVAL_PERIOD_SETS

Line 11: FROM hxc_approval_period_sets

7: FUNCTION get_approval_period_set_id ( p_approval_period_set_name IN VARCHAR2 ) RETURN NUMBER IS
8:
9: CURSOR csr_get_approval_period_set_id IS
10: SELECT approval_period_set_id
11: FROM hxc_approval_period_sets
12: WHERE name = p_approval_period_set_name;
13:
14: l_approval_period_set_id hxc_entity_groups.entity_group_id%TYPE;
15:

Line 104: FROM hxc_approval_period_sets aps

100: , DECODE( NVL( sc.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
101: INTO l_approval_period_comp_id
102: , l_ovn
103: , l_owner
104: FROM hxc_approval_period_sets aps
105: , hxc_approval_period_comps_v sc
106: WHERE sc.time_recipient_id = l_time_recipient_id
107: AND sc.recurring_period_id = l_recurring_period_id
108: AND sc.approval_period_set_id = aps.approval_period_set_id