APPS.HXC_TIMECARD_VALIDATION dependencies on HXC_RETRIEVAL_PROCESSES

Line 64: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%type;

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

Line 69: from hxc_retrieval_processes

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