APPS.IGS_FI_PRC_APINT dependencies on AP_TERMS

Line 362: -- Cursor for selecting the data from AP terms for the input parameter

358:
359: l_c_sup_type c_po_lkp%ROWTYPE;
360: l_c_grp_type c_po_lkp%ROWTYPE;
361:
362: -- Cursor for selecting the data from AP terms for the input parameter
363: CURSOR c_ap_term(cp_n_term_id ap_terms.term_id%TYPE) IS
364: SELECT name,
365: start_date_active,
366: end_date_active

Line 363: CURSOR c_ap_term(cp_n_term_id ap_terms.term_id%TYPE) IS

359: l_c_sup_type c_po_lkp%ROWTYPE;
360: l_c_grp_type c_po_lkp%ROWTYPE;
361:
362: -- Cursor for selecting the data from AP terms for the input parameter
363: CURSOR c_ap_term(cp_n_term_id ap_terms.term_id%TYPE) IS
364: SELECT name,
365: start_date_active,
366: end_date_active
367: FROM ap_terms

Line 367: FROM ap_terms

363: CURSOR c_ap_term(cp_n_term_id ap_terms.term_id%TYPE) IS
364: SELECT name,
365: start_date_active,
366: end_date_active
367: FROM ap_terms
368: WHERE term_id = cp_n_term_id;
369:
370: -- Cursor for selecting the multi org flag from the FND_PRODUCT_GROUPS
371: CURSOR c_fnd_prod IS

Line 402: -- Fetch the details from AP terms for the term id passed as input

398: -- mark that process shouldn't run anymore.
399: l_b_run_process := FALSE;
400: END IF;
401:
402: -- Fetch the details from AP terms for the term id passed as input
403: -- Incase no data is found, then this is an error condition
404: OPEN c_ap_term(p_n_inv_pay_term);
405: FETCH c_ap_term INTO l_c_ap_term;
406: IF c_ap_term%NOTFOUND THEN