DBA Data[Home] [Help]

APPS.HXC_TIMECARD_AUDIT dependencies on HXC_APPLICATION_SET_COMPS_V

Line 340: FROM hxc_application_set_comps_v

336: WHERE timecard_id = p_timecard_id;
337:
338: CURSOR get_application
339: IS SELECT time_recipient_name
340: FROM hxc_application_set_comps_v
341: WHERE application_set_id = p_application_set;
342:
343: l_transferred_to VARCHAR2(250);
344: l_rowid VARCHAR2(50);

Line 960: FROM hxc_application_set_comps_v

956:
957: BEGIN
958: SELECT 1
959: INTO l_exists
960: FROM hxc_application_set_comps_v
961: WHERE application_set_id = p_app_set_id
962: AND time_recipient_name = p_recipient;
963:
964: EXCEPTION

Line 977: FROM hxc_application_set_comps_v

973: -- Bug 14283008
974: -- Added rownum condition to avoid -1422 with HR and Payroll application set.
975: SELECT 1
976: INTO l_exists
977: FROM hxc_application_set_comps_v
978: WHERE application_set_id = p_app_set_id
979: AND time_recipient_name IN (p_recipient,'Human Resources')
980: AND ROWNUM < 2;
981: