APPS.HXC_TIMECARD_APPROVAL dependencies on HXC_TIME_RECIPIENTS

Line 14: TYPE time_recipient_table IS TABLE OF HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE INDEX BY BINARY_INTEGER;

10: APPLICATION_PERIOD_ID hxc_tc_ap_links.APPLICATION_PERIOD_ID%TYPE
11: );
12: TYPE tc_ap_links_table IS TABLE OF tc_ap_links INDEX BY BINARY_INTEGER;
13:
14: TYPE time_recipient_table IS TABLE OF HXC_TIME_RECIPIENTS.TIME_RECIPIENT_ID%TYPE INDEX BY BINARY_INTEGER;
15:
16: TYPE application_period_id_arr IS TABLE OF hxc_tc_ap_links.APPLICATION_PERIOD_ID%TYPE INDEX BY BINARY_INTEGER;
17:
18: TYPE time_building_block_id_arr IS TABLE OF hxc_ap_detail_links.TIME_BUILDING_BLOCK_ID%TYPE INDEX BY BINARY_INTEGER;

Line 167: p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE

163: cursor c_app_period
164: (p_resource_id hxc_time_building_blocks.resource_id%TYPE,
165: p_start_time hxc_time_building_blocks.start_time%TYPE,
166: p_stop_time hxc_time_building_blocks.stop_time%TYPE,
167: p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
168: ) is
169: select application_period_id
170: from hxc_app_period_summary
171: where resource_id = p_resource_id

Line 185: hxc_time_recipients htr

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
188: and hasc.time_recipient_id = htr.time_recipient_id;
189: