APPS.IGS_EN_GEN_LEGACY dependencies on HZ_PARTIES

Line 1161: CURSOR get_active_inst_cur(cp_person_id hz_parties.party_id%type,

1157: l_prog_label CONSTANT VARCHAR2(100) := 'igs.plsql.igs_en_gen_legacy.raise_person_type_event';
1158: l_label VARCHAR2(500);
1159: l_debug_str VARCHAR2(3200);
1160:
1161: CURSOR get_active_inst_cur(cp_person_id hz_parties.party_id%type,
1162: cp_system_type igs_pe_person_types.system_type%type ,
1163: cp_type_instance_id igs_pe_typ_instances_all.type_instance_id%TYPE) IS
1164: SELECT MAX(NVL(end_date,TO_DATE('4712/12/31','YYYY/MM/DD'))) FROM igs_pe_typ_instances_all pti
1165: WHERE pti.person_id = cp_person_id

Line 1877: FROM hz_parties hp, igs_pe_hz_parties ihp

1873: ***********************************************************************************************/
1874:
1875: CURSOR c_inst IS
1876: SELECT 'x'
1877: FROM hz_parties hp, igs_pe_hz_parties ihp
1878: WHERE hp.party_id = ihp.party_id AND
1879: ihp.inst_org_ind = 'I' AND
1880: ihp.oi_govt_institution_cd is not null AND
1881: ihp.oss_org_unit_cd = p_institution_name ;