eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGF_SL_CL_CHG_FILE dependencies on IGF_SL_CL_RECIPIENT

Line 202: ,igf_sl_cl_recipient recip

198: FROM igf_sl_lor_all lor
199: ,igf_sl_loans_all loans
200: ,igf_aw_award_all awd
201: ,igf_aw_fund_mast_all fmast
202: ,igf_sl_cl_recipient recip
203: WHERE loans.loan_id = lor.loan_id
204: AND loans.loan_chg_status = cp_c_loan_chg_status
205: AND awd.award_id = loans.award_id
206: AND fmast.fund_id = awd.fund_id

Line 1342: p_v_relationship_cd IN igf_sl_cl_recipient.relationship_cd%TYPE,

1338: p_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1339: p_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
1340: p_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1341: p_n_loan_id IN igf_sl_loans_all.loan_id%TYPE,
1342: p_v_relationship_cd IN igf_sl_cl_recipient.relationship_cd%TYPE,
1343: p_v_media_type IN igf_lookups_view.lookup_code%TYPE,
1344: p_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE,
1345: p_v_sch_non_ed_branch IN igf_sl_school_codes_v.alternate_identifier%TYPE
1346: ) AS

Line 1382: cp_v_relationship_cd IN igf_sl_cl_recipient.relationship_cd%TYPE,

1378: cp_n_sequence_number IN igs_ca_inst_all.sequence_number%TYPE,
1379: cp_n_fund_id IN igf_aw_fund_mast_all.fund_id%TYPE,
1380: cp_n_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
1381: cp_n_loan_id IN igf_sl_loans_all.loan_id%TYPE,
1382: cp_v_relationship_cd IN igf_sl_cl_recipient.relationship_cd%TYPE,
1383: cp_c_loan_chg_status IN igf_sl_loans_all.loan_chg_status%TYPE,
1384: cp_v_school_id IN igf_sl_school_codes_v.alternate_identifier%TYPE
1385: ) IS
1386: SELECT recip.rcpt_id

Line 1533: ,igf_sl_cl_recipient recip

1529: ,igf_sl_loans_all loans
1530: ,igf_aw_award_all awd
1531: ,igf_aw_fund_mast_all fmast
1532: ,igf_aw_fund_cat_all fcat
1533: ,igf_sl_cl_recipient recip
1534: ,igf_ap_fa_base_rec_all fabase
1535: WHERE lor.relationship_cd = cp_v_relationship_cd
1536: AND ((lor.loan_id = cp_n_loan_id) OR cp_n_loan_id IS NULL)
1537: AND loans.loan_id = lor.loan_id

Line 1560: CURSOR c_cl_recipient_dtls (cp_v_relationship_cd IN igf_sl_cl_recipient.relationship_cd%TYPE)IS

1556: FROM igf_lookups_view
1557: WHERE lookup_type = 'IGF_AP_SCHOOL_OPEID'
1558: AND lookup_code = cp_v_school_id;
1559:
1560: CURSOR c_cl_recipient_dtls (cp_v_relationship_cd IN igf_sl_cl_recipient.relationship_cd%TYPE)IS
1561: SELECT recipient_id
1562: ,recipient_type
1563: ,recip_non_ed_brc_id
1564: FROM igf_sl_cl_recipient

Line 1564: FROM igf_sl_cl_recipient

1560: CURSOR c_cl_recipient_dtls (cp_v_relationship_cd IN igf_sl_cl_recipient.relationship_cd%TYPE)IS
1561: SELECT recipient_id
1562: ,recipient_type
1563: ,recip_non_ed_brc_id
1564: FROM igf_sl_cl_recipient
1565: WHERE relationship_cd = cp_v_relationship_cd;
1566:
1567: CURSOR c_sl_lender (cp_n_recipient_id IN igf_sl_cl_recipient.recipient_id%TYPE) IS
1568: SELECT lender_id

Line 1567: CURSOR c_sl_lender (cp_n_recipient_id IN igf_sl_cl_recipient.recipient_id%TYPE) IS

1563: ,recip_non_ed_brc_id
1564: FROM igf_sl_cl_recipient
1565: WHERE relationship_cd = cp_v_relationship_cd;
1566:
1567: CURSOR c_sl_lender (cp_n_recipient_id IN igf_sl_cl_recipient.recipient_id%TYPE) IS
1568: SELECT lender_id
1569: ,description
1570: FROM igf_sl_lender
1571: WHERE lender_id = cp_n_recipient_id

Line 1574: CURSOR c_sl_guarantor (cp_n_recipient_id IN igf_sl_cl_recipient.recipient_id%TYPE) IS

1570: FROM igf_sl_lender
1571: WHERE lender_id = cp_n_recipient_id
1572: AND enabled = 'Y';
1573:
1574: CURSOR c_sl_guarantor (cp_n_recipient_id IN igf_sl_cl_recipient.recipient_id%TYPE) IS
1575: SELECT guarantor_id
1576: ,description
1577: FROM igf_sl_guarantor
1578: WHERE guarantor_id = cp_n_recipient_id

Line 1582: CURSOR c_sl_servicer (cp_n_recipient_id IN igf_sl_cl_recipient.recipient_id%TYPE) IS

1578: WHERE guarantor_id = cp_n_recipient_id
1579: AND enabled = 'Y';
1580:
1581:
1582: CURSOR c_sl_servicer (cp_n_recipient_id IN igf_sl_cl_recipient.recipient_id%TYPE) IS
1583: SELECT servicer_id
1584: ,description
1585: FROM igf_sl_servicer
1586: WHERE servicer_id = cp_n_recipient_id

Line 1654: l_v_relationship_cd igf_sl_cl_recipient.relationship_cd%TYPE;

1650: l_n_fund_id igf_aw_fund_mast_all.fund_id%TYPE;
1651: l_v_school_id igf_sl_school_codes_v.alternate_identifier%TYPE;
1652: l_v_media_type igf_lookups_view.lookup_code%TYPE;
1653: l_v_sch_non_ed_branch igf_sl_school_codes_v.alternate_identifier%TYPE;
1654: l_v_relationship_cd igf_sl_cl_recipient.relationship_cd%TYPE;
1655:
1656: l_v_alt_code igs_ca_inst_all.alternate_code%TYPE;
1657:
1658: -- variables for change send header record

Line 1666: l_n_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;

1662: l_v_file_crea_date VARCHAR2(8);
1663: l_v_file_crea_time VARCHAR2(6);
1664: l_v_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1665: l_v_source_name igf_ap_school_opeid_v.meaning%TYPE;
1666: l_n_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;
1667: l_v_recipient_name igf_sl_servicer.description%TYPE;
1668: l_v_recipient_type igf_sl_cl_recipient.recipient_type%TYPE;
1669: l_v_recip_non_edbrc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;
1670: l_n_lender_id igf_sl_lender.lender_id%TYPE;

Line 1668: l_v_recipient_type igf_sl_cl_recipient.recipient_type%TYPE;

1664: l_v_cl_version igf_sl_cl_setup_all.cl_version%TYPE;
1665: l_v_source_name igf_ap_school_opeid_v.meaning%TYPE;
1666: l_n_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;
1667: l_v_recipient_name igf_sl_servicer.description%TYPE;
1668: l_v_recipient_type igf_sl_cl_recipient.recipient_type%TYPE;
1669: l_v_recip_non_edbrc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;
1670: l_n_lender_id igf_sl_lender.lender_id%TYPE;
1671: l_n_guarantor_id igf_sl_guarantor.guarantor_id%TYPE;
1672: l_n_servicer_id igf_sl_servicer.servicer_id%TYPE;

Line 1669: l_v_recip_non_edbrc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;

1665: l_v_source_name igf_ap_school_opeid_v.meaning%TYPE;
1666: l_n_recipient_id igf_sl_cl_recipient.recipient_id%TYPE;
1667: l_v_recipient_name igf_sl_servicer.description%TYPE;
1668: l_v_recipient_type igf_sl_cl_recipient.recipient_type%TYPE;
1669: l_v_recip_non_edbrc_id igf_sl_cl_recipient.recip_non_ed_brc_id%TYPE;
1670: l_n_lender_id igf_sl_lender.lender_id%TYPE;
1671: l_n_guarantor_id igf_sl_guarantor.guarantor_id%TYPE;
1672: l_n_servicer_id igf_sl_servicer.servicer_id%TYPE;
1673: l_v_filler_2_char VARCHAR2(2);