APPS.HXC_TIMEKEEPER_PROCESS dependencies on HXC_TK_TIMEKEEPER_SUBMITS

Line 6140: FROM hxc_tk_timekeeper_submits;

6136: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
6137: ) IS
6138: CURSOR crs_max_submit IS
6139: SELECT MAX (submission_id)
6140: FROM hxc_tk_timekeeper_submits;
6141:
6142: l_max_submission_id NUMBER
6143: /*ADVICE(4175): NUMBER has no precision [315] */
6144: ;

Line 6165: SELECT hxc_tk_timekeeper_submits_s.NEXTVAL

6161: IF l_max_submission_id IS NULL THEN
6162: l_max_submission_id := 1;
6163: END IF;
6164:
6165: SELECT hxc_tk_timekeeper_submits_s.NEXTVAL
6166: INTO l_next_val
6167: FROM DUAL;
6168:
6169: IF l_max_submission_id < l_next_val THEN

Line 6248: FROM hxc_tk_timekeeper_submits

6244: CURSOR crs_resource_id (
6245: p_submit_id IN NUMBER
6246: ) IS
6247: SELECT DISTINCT (resource_id) resource_id
6248: FROM hxc_tk_timekeeper_submits
6249: WHERE submission_id = p_submit_id;
6250:
6251: CURSOR crs_employee_info (
6252: p_resource_id IN NUMBER,