APPS.IGS_PE_TYP_INSTANCES_PKG dependencies on IGS_PE_DATA_ELEMENT

Line 704: CURSOR Data_Emt (p_data_element IGS_PE_DATA_ELEMENT.data_element%TYPE) IS

700: FROM igs_pe_stup_data_emt
701: WHERE person_type_code = p_person_type_code
702: AND NVL(required_ind, 'S') IN ('M');
703:
704: CURSOR Data_Emt (p_data_element IGS_PE_DATA_ELEMENT.data_element%TYPE) IS
705: SELECT table_name, column_name
706: FROM igs_pe_data_element
707: WHERE UPPER(data_element) = UPPER(p_data_element) ;
708:

Line 706: FROM igs_pe_data_element

702: AND NVL(required_ind, 'S') IN ('M');
703:
704: CURSOR Data_Emt (p_data_element IGS_PE_DATA_ELEMENT.data_element%TYPE) IS
705: SELECT table_name, column_name
706: FROM igs_pe_data_element
707: WHERE UPPER(data_element) = UPPER(p_data_element) ;
708:
709: CURSOR c_lookup_meaning(cp_lookup_type VARCHAR2,
710: cp_lookup_code VARCHAR2) IS