APPS.IGS_CO_GEN_003 dependencies on IGS_PE_RES_DTLS_ALL

Line 297: l_column_value igs_pe_res_dtls_all.attribute1%TYPE;

293: AND usg.enabled_flag = 'Y'
294: AND usg.application_id = 8405;
295:
296: l_return_value VARCHAR2(6000);
297: l_column_value igs_pe_res_dtls_all.attribute1%TYPE;
298:
299: BEGIN
300:
301: -- Check if the required parameter values are passed as Null. If any of these are null then return NULL value

Line 311: ' FROM igs_pe_res_dtls_all '||

307:
308: FOR rec_cur_enabled_attributes IN cur_enabled_attributes LOOP
309: -- Get the registered flex filed Column values for the Resident Details
310: EXECUTE IMMEDIATE ' SELECT ' || rec_cur_enabled_attributes.application_column_name ||
311: ' FROM igs_pe_res_dtls_all '||
312: ' WHERE resident_details_id = :1'
313: INTO l_column_value
314: USING p_resident_details_id;
315: