APPS.IGF_GR_GEN dependencies on IGF_GR_RFMS_DISB

Line 865: CURSOR cur_gr_rfms_disb(p_rfmb_id igf_gr_rfms_disb.rfmb_id%TYPE)

861: orig_action_code = 'S';
862:
863: cur_get_rfms cur_gr_rfms%ROWTYPE;
864:
865: CURSOR cur_gr_rfms_disb(p_rfmb_id igf_gr_rfms_disb.rfmb_id%TYPE)
866: IS
867: SELECT
868: *
869: FROM

Line 870: igf_gr_rfms_disb

866: IS
867: SELECT
868: *
869: FROM
870: igf_gr_rfms_disb
871: WHERE
872: rfmb_id = p_rfmb_id AND
873: disb_ack_act_status = 'S';
874:

Line 884: l_disb_rfmb_id igf_gr_rfms_disb.rfmb_id%TYPE;

880: l_count NUMBER;
881: l_error_code igf_gr_rfms_error.edit_code%TYPE;
882: lb_error_cd BOOLEAN := FALSE;
883: l_rfmb_id igf_gr_rfms.rfmb_id%TYPE;
884: l_disb_rfmb_id igf_gr_rfms_disb.rfmb_id%TYPE;
885:
886: BEGIN
887:
888: l_count := 1;

Line 1077: igf_gr_rfms_disb_pkg.update_row (

1073: fnd_file.put_line(fnd_file.log,igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','ORIGINATION_ID') ||' : ' || cur_get_rfms_disb.origination_id
1074: ||' , '
1075: ||igf_aw_gen.lookup_desc('IGF_GR_LOOKUPS','DISB_REF_NUM') ||' : ' || cur_get_rfms_disb.disb_ref_num);
1076:
1077: igf_gr_rfms_disb_pkg.update_row (
1078: x_rowid => cur_get_rfms_disb.row_id,
1079: x_rfmd_id => cur_get_rfms_disb.rfmd_id ,
1080: x_origination_id => cur_get_rfms_disb.origination_id,
1081: x_disb_ref_num => cur_get_rfms_disb.disb_ref_num,

Line 1238: igf_gr_rfms_disb

1234: IS
1235: SELECT
1236: MIN(disb_ref_num)
1237: FROM
1238: igf_gr_rfms_disb
1239: WHERE
1240: origination_id = p_orig_id;
1241:
1242: ln_min_num NUMBER(10);