APPS.HXC_TIMECARD_VALIDATION dependencies on HXC_RETRIEVAL_PROCESSES

Line 62: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%type;

58: Return number is
59:
60: c_ret_pro retrieval_ref_cursor;
61: l_sql VARCHAR2(32000);
62: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%type;
63:
64: Begin
65:
66: l_sql := 'select retrieval_process_id

Line 67: from hxc_retrieval_processes

63:
64: Begin
65:
66: l_sql := 'select retrieval_process_id
67: from hxc_retrieval_processes
68: where time_recipient_id = '|| p_time_recipient_id
69: ||' and name = '||p_retrieval_function;
70:
71: open c_ret_pro for l_sql;