APPS.HXC_TIMEKEEPER_PROCESS dependencies on HXC_TK_TIMEKEEPER_SUBMITS

Line 4788: FROM hxc_tk_timekeeper_submits;

4784: p_messages IN OUT NOCOPY hxc_self_service_time_deposit.message_table
4785: ) IS
4786: CURSOR crs_max_submit IS
4787: SELECT MAX (submission_id)
4788: FROM hxc_tk_timekeeper_submits;
4789:
4790: l_max_submission_id NUMBER
4791: /*ADVICE(4175): NUMBER has no precision [315] */
4792: ;

Line 4813: SELECT hxc_tk_timekeeper_submits_s.NEXTVAL

4809: IF l_max_submission_id IS NULL THEN
4810: l_max_submission_id := 1;
4811: END IF;
4812:
4813: SELECT hxc_tk_timekeeper_submits_s.NEXTVAL
4814: INTO l_next_val
4815: FROM DUAL;
4816:
4817: IF l_max_submission_id < l_next_val THEN

Line 4896: FROM hxc_tk_timekeeper_submits

4892: CURSOR crs_resource_id (
4893: p_submit_id IN NUMBER
4894: ) IS
4895: SELECT DISTINCT (resource_id) resource_id
4896: FROM hxc_tk_timekeeper_submits
4897: WHERE submission_id = p_submit_id;
4898:
4899: CURSOR crs_employee_info (
4900: p_resource_id IN NUMBER,