APPS.IGS_HE_CREATE_EXTRACT_PKG dependencies on IGS_HE_EX_RN_DAT_LN

Line 159: CURSOR c_extract_field(cp_line_number igs_he_ex_rn_dat_ln.line_number%type) IS

155: AND ufld.field_number = sfld.field_number
156: AND ufld.user_return_subclass = uclas.user_return_subclass;
157:
158: -- Get every field in an extract for given line
159: CURSOR c_extract_field(cp_line_number igs_he_ex_rn_dat_ln.line_number%type) IS
160: SELECT value, override_value, field_number
161: FROM igs_he_ex_rn_dat_fd
162: WHERE extract_run_id = p_extract_run_id
163: AND line_number = cp_line_number

Line 190: l_line_number igs_he_ex_rn_dat_ln.line_number%TYPE;

186: l_file utl_file.file_type := NULL;
187: l_sqlstmt VARCHAR2(32767);
188: l_prs_grp_sql VARCHAR2(32767);
189: l_extract_dtls c_extract_dtls%ROWTYPE;
190: l_line_number igs_he_ex_rn_dat_ln.line_number%TYPE;
191:
192: l_bind2 NUMBER;
193: l_bind3 DATE;
194: l_bind4 DATE;

Line 249: ' FROM igs_he_ex_rn_dat_ln ln ' ||

245:
246:
247: -- Construct Line SQL statement.
248: l_sqlstmt := ' SELECT line_number ' ||
249: ' FROM igs_he_ex_rn_dat_ln ln ' ||
250: ' WHERE ln.extract_run_id = :BIND1' ||
251: ' AND ln.exclude_from_file = ''N'' ';
252:
253: