DBA Data[Home] [Help]

APPS.IGS_AD_GEN_001 dependencies on IGS_PE_PERSON_TYPES

Line 2280: FROM igs_pe_stup_data_emt sdt, igs_pe_person_types pt

2276: AND required_ind = 'P';
2277:
2278: CURSOR per_type_req_man_ins IS
2279: SELECT 'x'
2280: FROM igs_pe_stup_data_emt sdt, igs_pe_person_types pt
2281: WHERE sdt.person_type_code = pt.person_type_code
2282: AND pt.system_type = 'OTHER'
2283: AND UPPER(sdt.data_element) = UPPER(p_data_element)
2284: AND sdt.required_ind = 'M';

Line 2288: FROM igs_pe_stup_data_emt sdt, igs_pe_person_types pt

2284: AND sdt.required_ind = 'M';
2285:
2286: CURSOR per_type_req_pre_ins IS
2287: SELECT 'x'
2288: FROM igs_pe_stup_data_emt sdt, igs_pe_person_types pt
2289: WHERE sdt.person_type_code = pt.person_type_code
2290: AND pt.system_type = 'OTHER'
2291: AND UPPER(sdt.data_element) = UPPER(p_data_element)
2292: AND sdt.required_ind = 'P';