APPS.HXC_TIMECARD_APPROVAL dependencies on HXC_APPLICATION_SETS_V

Line 183: from hxc_application_sets_v has,

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

Line 190: l_application_set_id HXC_APPLICATION_SETS_V.APPLICATION_SET_ID%TYPE;

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