APPS.IGF_GR_PELL dependencies on IGF_AP_ISIR_MATCHED

Line 155: igf_ap_isir_matched isir

151: isir.sec_efc_type,
152: isir.isir_id
153: FROM
154: igf_ap_fa_base_rec faconv,
155: igf_ap_isir_matched isir
156: WHERE
157: x_base_id = faconv.base_id AND
158: faconv.base_id = isir.base_id AND
159: isir.active_isir = 'Y'

Line 339: FROM igf_ap_isir_matched

335:
336: -- Cursor to select payment isir.
337: CURSOR cur_payment_isir(c_base_id NUMBER) IS
338: SELECT isir_id
339: FROM igf_ap_isir_matched
340: WHERE base_id = c_base_id
341: AND payment_isir = 'Y';
342:
343:

Line 1040: igf_ap_isir_matched isir

1036: SELECT
1037: isir.original_ssn,
1038: isir.orig_name_id
1039: FROM
1040: igf_ap_isir_matched isir
1041: WHERE isir.base_id = x_base_id
1042: AND isir.active_isir = 'Y' ;
1043:
1044: l_isir c_isir%rowtype;