APPS.HXC_PROJ_PAY_DEP_VALIDATION dependencies on HXC_RETRIEVAL_PROCESSES

Line 68: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%type;

64: p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE)
65: IS
66:
67: l_count NUMBER := 0;
68: l_retrieval_process_id hxc_retrieval_processes.retrieval_process_id%type;
69:
70: l_index NUMBER;
71: l_active_building_block_ids VARCHAR2(32767) := null;
72: l_sql_stmt VARCHAR2(32767);

Line 111: FROM hxc_retrieval_processes

107:
108:
109: SELECT retrieval_process_id
110: INTO l_retrieval_process_id
111: FROM hxc_retrieval_processes
112: WHERE name = 'BEE Retrieval Process';
113:
114: l_index := p_blocks.first;
115: