APPS.IGF_SL_CL_ORIG dependencies on IGS_OR_ORG_ALT_IDS

Line 155: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;

151: lv_p_foreign_postal_code igf_sl_lor_loc_all.s_foreign_postal_code%TYPE;
152:
153: x_return_status VARCHAR2(1);
154: x_msg_data VARCHAR2(30);
155: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
156:
157:
158: -- Query optimized by using the table igf_sl_cl_recipient instead of the view igf_sl_cl_recipient_v (bug #3691146)
159: CURSOR cur_recip_desc( p_relationship_cd VARCHAR2)