APPS.IGF_AP_GEN dependencies on IGF_AP_ISIR_MATCHED_ALL

Line 545: lv_stmt := 'SELECT '||p_sar_field_name ||' FROM igf_ap_isir_matched_all WHERE payment_isir = ''Y'' AND system_record_type = ''ORIGINAL'' AND base_id = '||to_char(p_base_id);

541: ELSE
542:
543: IF p_sar_field_name IS NOT NULL THEN
544: lv_cur := DBMS_SQL.OPEN_CURSOR;
545: lv_stmt := 'SELECT '||p_sar_field_name ||' FROM igf_ap_isir_matched_all WHERE payment_isir = ''Y'' AND system_record_type = ''ORIGINAL'' AND base_id = '||to_char(p_base_id);
546:
547: DBMS_SQL.PARSE(lv_cur, lv_stmt, 2);
548: DBMS_SQL.DEFINE_COLUMN(lv_cur, 1, lv_retval, 30);
549: lv_rows := DBMS_SQL.EXECUTE_AND_FETCH(lv_cur);

Line 571: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE

567: FUNCTION get_indv_efc_4_term(
568: p_base_id IN igf_ap_fa_base_rec_all.base_id%TYPE,
569: p_cal_type IN igf_ap_fa_base_rec_all.ci_cal_type%TYPE,
570: p_sequence_number IN igf_ap_fa_base_rec_all.ci_sequence_number%TYPE,
571: p_isir_id IN igf_ap_isir_matched_all.isir_id%TYPE
572: ) RETURN NUMBER AS
573: /*
574: || Created By : rasahoo
575: || Created On : 15-10-2003

Line 587: cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE

583: */
584:
585: CURSOR c_cum_efc(
586: cp_base_id igf_ap_fa_base_rec_all.base_id%TYPE,
587: cp_isir_id igf_ap_isir_matched_all.isir_id%TYPE
588: ) IS
589: SELECT distinct ca.alternate_code,
590: ca.start_dt ld_start_dt,
591: ca.end_dt ld_end_dt,

Line 621: FROM igf_ap_isir_matched_all isir,

617: 9 , PRIMARY_EFC,
618: 10, PRIMARY_ALTERNATE_MONTH_10,
619: 11, PRIMARY_ALTERNATE_MONTH_11,
620: 12, PRIMARY_ALTERNATE_MONTH_12 ) ) efc
621: FROM igf_ap_isir_matched_all isir,
622: igf_ap_fa_base_rec_all fa,
623: igs_ca_inst_all ca,
624: igf_aw_coa_itm_terms coa
625: WHERE coa.base_id = fa.base_id