APPS.IGS_AD_VAL_ACAI dependencies on IGS_PE_TYP_INSTANCES

Line 2896: FROM igs_pe_person_types pt,igs_pe_typ_instances pti

2892: BEGIN
2893: DECLARE
2894: CURSOR pe_typ_cd IS
2895: SELECT pti.person_type_code
2896: FROM igs_pe_person_types pt,igs_pe_typ_instances pti
2897: WHERE pti.person_id = p_person_id
2898: AND pti.person_type_code = pt.person_type_code
2899: AND pt.system_type = 'STAFF'
2900: AND SYSDATE BETWEEN pti.start_date AND NVL(pti.end_date,SYSDATE);

Line 2926: FROM igs_pe_person_types pt,igs_pe_typ_instances pti

2922: RETURN BOOLEAN AS
2923:
2924: CURSOR pe_typ_cd IS
2925: SELECT pti.person_type_code
2926: FROM igs_pe_person_types pt,igs_pe_typ_instances pti
2927: WHERE pti.person_id = p_person_id
2928: AND pti.person_type_code = pt.person_type_code
2929: AND pt.system_type IN ('STAFF', 'FACULTY')
2930: AND SYSDATE BETWEEN pti.start_date AND NVL(pti.end_date,SYSDATE);

Line 2970: FROM igs_pe_person_types pt,igs_pe_typ_instances pti

2966: RETURN BOOLEAN AS
2967:
2968: CURSOR pe_typ_cd IS
2969: SELECT pti.person_type_code
2970: FROM igs_pe_person_types pt,igs_pe_typ_instances pti
2971: WHERE pti.person_id = p_person_id
2972: AND pti.person_type_code = pt.person_type_code
2973: AND pt.system_type IN ('STAFF', 'FACULTY' , 'EVALUATOR')
2974: AND SYSDATE BETWEEN pti.start_date AND NVL(pti.end_date,SYSDATE);