APPS.AP_AUTOSELECT_PKG dependencies on AP_PAYMENT_UTIL_PKG

Line 81: decode(Ap_Payment_Util_Pkg.is_federal_installed(AI.org_id),

77: annual_interest_rate,
78: AI.invoice_currency_code,
79: ASI.payment_currency_code,
80: /* bug 5233279. For Federal Installation Exclusive payment Flag is required */
81: decode(Ap_Payment_Util_Pkg.is_federal_installed(AI.org_id),
82: 'Y', AI.exclusive_payment_flag, 'N'),
83: asp.interest_accts_pay_ccid,
84: ai.org_id
85: FROM ap_interest_periods,

Line 1252: and Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'N';

1248: and asi2.payment_num = asi.original_payment_num
1249: and asi2.checkrun_id = p_checkrun_id)
1250: where asi.checkrun_id = p_checkrun_id
1251: and asi.original_invoice_id is not null
1252: and Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'N';
1253:
1254:
1255:
1256: --5007819

Line 1315: and Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'Y'

1311: update ap_selected_invoices_all asi
1312: set payment_grouping_number = null
1313: where asi.checkrun_id = p_checkrun_id
1314: and asi.payment_grouping_number is not null
1315: and Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'Y'
1316: and exists (
1317: select /*+NO_UNNEST */ NULL
1318: from ap_selected_invoices_all asi2
1319: where asi2.original_invoice_id is not null

Line 1331: and Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'N'

1327: -- Bug 5645890, Added the hint
1328: update ap_selected_invoices_all asi
1329: set exclusive_payment_flag = 'N'
1330: where asi.checkrun_id = p_checkrun_id
1331: and Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'N'
1332: and exists (
1333: select NULL
1334: from ap_selected_invoices_all asi2
1335: where asi2.original_invoice_id is not null