APPS.HXC_APR_UPLOAD_PKG dependencies on HXC_APPROVAL_PERIOD_SETS

Line 21: FROM hxc_approval_period_sets

17: , DECODE( NVL(last_updated_by,-1), 1, 'SEED', 'CUSTOM')
18: INTO l_approval_period_set_id
19: , l_ovn
20: , l_owner
21: FROM hxc_approval_period_sets
22: WHERE name = P_APPROVAL_PERIOD_SET_NAME;
23:
24: -- NOTE - there is no update section since there is nothing to update
25:

Line 29: hxc_approval_period_sets_api.create_approval_period_sets(

25:
26: EXCEPTION WHEN NO_DATA_FOUND
27: THEN
28:
29: hxc_approval_period_sets_api.create_approval_period_sets(
30: p_approval_period_set_id => l_approval_period_set_id
31: , p_object_version_number => l_ovn
32: , p_name => p_approval_period_set_name );
33: