APPS.IGF_AP_ISIR_IMPORT_PKG dependencies on IGS_OR_ORG_ALT_IDS

Line 131: x_fed_sch_cd igs_or_org_alt_ids.org_alternate_id%TYPE;

127: FROM igf_ap_isir_matched
128: WHERE isir_id = p_ISIR_id;
129: l_get_base_id_rec cur_get_base_id%ROWTYPE;
130:
131: x_fed_sch_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
132: x_return_status VARCHAR2(1);
133: x_msg_data VARCHAR2(30);
134:
135: BEGIN

Line 340: igs_or_org_alt_ids oli,

336: SELECT
337: 'Y'
338: FROM
339: hz_parties hz,
340: igs_or_org_alt_ids oli,
341: igs_or_org_alt_idtyp olt
342: WHERE oli.org_structure_id = hz.party_number
343: AND oli.org_alternate_id_type = olt.org_alternate_id_type
344: AND SYSDATE BETWEEN oli.start_date AND nvl (end_date, SYSDATE)