APPS.HXC_TIMECARD_APPROVAL dependencies on HXC_APPLICATION_SETS_V

Line 182: from hxc_application_sets_v has,

178:
179: cursor c_get_apps_from_app_set
180: (p_app_set number) is
181: select htr.time_recipient_id
182: from hxc_application_sets_v has,
183: hxc_application_set_comps_v hasc,
184: hxc_time_recipients htr
185: where has.application_set_id = p_app_set
186: and hasc.application_set_id = has.application_set_id

Line 189: l_application_set_id HXC_APPLICATION_SETS_V.APPLICATION_SET_ID%TYPE;

185: where has.application_set_id = p_app_set
186: and hasc.application_set_id = has.application_set_id
187: and hasc.time_recipient_id = htr.time_recipient_id;
188:
189: l_application_set_id HXC_APPLICATION_SETS_V.APPLICATION_SET_ID%TYPE;
190: l_appl_recipients time_recipient_table;
191: l_time_building_block_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE ;
192: l_object_version_number HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE ;
193: l_resource_id HXC_TIME_BUILDING_BLOCKS.RESOURCE_ID%TYPE ;