DBA Data[Home] [Help]

APPS.IGF_GR_REPACKAGE dependencies on IGF_GR_RFMS_DISB_ALL

Line 479: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE

475: l_last_disb_num NUMBER;
476:
477: CURSOR c_rfmb_disb(
478: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE,
479: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE
480: ) IS
481: SELECT rfmd.rowid row_id,
482: rfmd.*
483: FROM igf_gr_rfms_disb_all rfmd

Line 483: FROM igf_gr_rfms_disb_all rfmd

479: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE
480: ) IS
481: SELECT rfmd.rowid row_id,
482: rfmd.*
483: FROM igf_gr_rfms_disb_all rfmd
484: WHERE
485: rfmd.origination_id = cp_origination_id AND
486: rfmd.disb_ref_num = cp_disb_num ;
487:

Line 491: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE

487:
488:
489: CURSOR c_rfmd_extra(
490: cp_origination_id igf_gr_rfms_disb_v.origination_id%TYPE,
491: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE
492: ) IS
493: SELECT rfmd.rowid row_id,
494: rfmd.*
495: FROM igf_gr_rfms_disb_all rfmd

Line 495: FROM igf_gr_rfms_disb_all rfmd

491: cp_disb_num igf_gr_rfms_disb_all.disb_ref_num%TYPE
492: ) IS
493: SELECT rfmd.rowid row_id,
494: rfmd.*
495: FROM igf_gr_rfms_disb_all rfmd
496: WHERE
497: rfmd.origination_id = cp_origination_id AND
498: rfmd.disb_ref_num > cp_disb_num ;
499: