APPS.IGS_AD_GEN_010 dependencies on IGS_PE_PERSON_ID_TYP

Line 15: cst_tac CONSTANT IGS_PE_PERSON_ID_TYP.s_person_id_type%TYPE := 'TAC';

11: gv_other_detail VARCHAR2(255);
12: BEGIN -- admp_get_tac_api
13: -- This function gets the TAC alternate person ID
14: DECLARE
15: cst_tac CONSTANT IGS_PE_PERSON_ID_TYP.s_person_id_type%TYPE := 'TAC';
16: v_tac_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
17: CURSOR c_api_pit IS
18: SELECT api.api_person_id
19: FROM IGS_PE_ALT_PERS_ID api,

Line 20: IGS_PE_PERSON_ID_TYP pit

16: v_tac_id IGS_PE_ALT_PERS_ID.api_person_id%TYPE;
17: CURSOR c_api_pit IS
18: SELECT api.api_person_id
19: FROM IGS_PE_ALT_PERS_ID api,
20: IGS_PE_PERSON_ID_TYP pit
21: WHERE api.pe_person_id = p_person_id AND
22: pit.person_id_type = api.person_id_type AND
23: pit.s_person_id_type = cst_tac;
24: BEGIN

Line 245: IGS_PE_PERSON_ID_TYP pit

241: v_course_ins_found BOOLEAN;
242: CURSOR c_tac_id_api IS
243: SELECT api.pe_person_id
244: FROM IGS_PE_ALT_PERS_ID api,
245: IGS_PE_PERSON_ID_TYP pit
246: WHERE pit.s_person_id_type = 'TAC' AND
247: api.person_id_type = pit.person_id_type AND
248: api.api_person_id = p_tac_person_id;
249: CURSOR c_tac_id_pe(