APPS.IGF_SL_CL_CHG_PRC SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 55

SELECT  isl.anticip_compl_date anticipated_completion_date
        ,islv.loan_per_end_date loan_end_date
FROM    igf_sl_lor_v isl,
        igf_sl_loans_v islv
WHERE   isl.loan_id = islv.loan_id and
        isl.loan_id  = cp_n_loan_id;

Line: 63

SELECT   clchgsnd.award_id
        ,clchgsnd.loan_number_txt
FROM    igf_sl_clchsn_dtls clchgsnd
WHERE   clchgsnd.clchgsnd_id = cp_n_clchgsnd_id;

Line: 69

SELECT  lar.loan_id
FROM    igf_sl_loans_all lar
WHERE   lar.loan_number = cp_v_loan_number;

Line: 74

SELECT   lor.p_person_id        borrower_id
        ,lor.relationship_cd    relationship_cd
        ,lor.cl_seq_number   cl_seq_number
FROM    igf_sl_lor_all lor
WHERE   lor.loan_id = cp_n_loan_id;

Line: 81

SELECT  awd.base_id
FROM    igf_aw_award_all awd
WHERE   awd.award_id = cp_n_award_id;

Line: 86

SELECT  fabase.person_id
FROM    igf_ap_fa_base_rec_all fabase
WHERE   fabase.base_id = cp_n_base_id;

Line: 91

SELECT   rcpt.guarantor_id
        ,rcpt.lender_id
FROM     igf_sl_cl_recipient rcpt
WHERE    relationship_cd = cp_v_relationship_cd;