DBA Data[Home] [Help]

APPS.IGF_SL_LAR_CREATION dependencies on IGS_OR_ORG_ALT_IDS

Line 780: x_dlsch_cd igs_or_org_alt_ids.org_alternate_id%TYPE;

776: l_ssn igf_ap_isir_matched_all.current_ssn%TYPE;
777:
778: x_return_status VARCHAR2(1);
779: x_msg_data VARCHAR2(30);
780: x_dlsch_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
781: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
782: x_sch_non_ed_brc_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
783:
784: CURSOR cur_loan_num (p_loan_number igf_sl_loans_all.loan_number%TYPE) IS

Line 781: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;

777:
778: x_return_status VARCHAR2(1);
779: x_msg_data VARCHAR2(30);
780: x_dlsch_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
781: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
782: x_sch_non_ed_brc_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
783:
784: CURSOR cur_loan_num (p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
785: SELECT rowid

Line 782: x_sch_non_ed_brc_cd igs_or_org_alt_ids.org_alternate_id%TYPE;

778: x_return_status VARCHAR2(1);
779: x_msg_data VARCHAR2(30);
780: x_dlsch_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
781: x_ope_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
782: x_sch_non_ed_brc_cd igs_or_org_alt_ids.org_alternate_id%TYPE;
783:
784: CURSOR cur_loan_num (p_loan_number igf_sl_loans_all.loan_number%TYPE) IS
785: SELECT rowid
786: FROM igf_sl_loans_all