APPS.IGF_AP_BATCH_VER_PRC_PKG dependencies on IGF_AP_ISIR_MATCHED_ALL

Line 1432: igf_ap_isir_matched_all im,

1428: pe.person_first_name given_names,
1429: pe.person_last_name surname,
1430: im.isir_id
1431: FROM igf_ap_fa_base_rec_all far,
1432: igf_ap_isir_matched_all im,
1433: hz_parties pe
1434: WHERE far.person_id = pe.party_id
1435: AND far.ci_cal_type = NVL(lv_ci_cal_type,far.ci_cal_type)
1436: AND far.ci_sequence_number = NVL(lv_ci_sequence_number, far.ci_sequence_number)

Line 1443: CURSOR cur_chk_batched ( cp_base_id igf_ap_isir_matched_all.base_id%TYPE,

1439: AND im.system_record_type = 'ORIGINAL'
1440: AND im.payment_isir = 'Y';
1441:
1442:
1443: CURSOR cur_chk_batched ( cp_base_id igf_ap_isir_matched_all.base_id%TYPE,
1444: cp_corr_status igf_ap_isir_corr_all.correction_status%TYPE
1445: )
1446: IS
1447: SELECT isir.base_id

Line 1448: FROM igf_ap_isir_matched_all isir,

1444: cp_corr_status igf_ap_isir_corr_all.correction_status%TYPE
1445: )
1446: IS
1447: SELECT isir.base_id
1448: FROM igf_ap_isir_matched_all isir,
1449: igf_ap_isir_corr_all corr
1450: WHERE isir.base_id = cp_base_id
1451: AND isir.isir_id = corr.isir_id
1452: AND NVL(corr.correction_status,'X') = cp_corr_status;

Line 1517: ln_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE;

1513: p_msg_count NUMBER;
1514: p_msg_text VARCHAR2(2000);
1515: lv_update_ssn VARCHAR2(1);
1516: SKIP_STUDENT EXCEPTION;
1517: ln_corr_isir_id igf_ap_isir_matched_all.isir_id%TYPE;
1518:
1519:
1520: BEGIN
1521: