APPS.AP_AUTOSELECT_PKG dependencies on AP_PAYMENT_UTIL_PKG

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

271: /* Added for Bug#12835170 End */
272: AI.invoice_currency_code,
273: ASI.payment_currency_code,
274: /* bug 5233279. For Federal Installation Exclusive payment Flag is required */
275: decode(Ap_Payment_Util_Pkg.is_federal_installed(AI.org_id),
276: 'Y', AI.exclusive_payment_flag, 'N'),
277: asp.interest_accts_pay_ccid,
278: ai.org_id
279: FROM /* ap_interest_periods, Bug#12835170 */

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

1831: and asi2.payment_num = asi.original_payment_num
1832: and asi2.checkrun_id = p_checkrun_id)
1833: where asi.checkrun_id = p_checkrun_id
1834: and asi.original_invoice_id is not null
1835: and (Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'N'
1836: /* following 2 lines added for bug 10318301 */
1837: or (Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'Y'
1838: and asi.exclusive_payment_flag = 'N'));
1839:

Line 1837: or (Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'Y'

1833: where asi.checkrun_id = p_checkrun_id
1834: and asi.original_invoice_id is not null
1835: and (Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'N'
1836: /* following 2 lines added for bug 10318301 */
1837: or (Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'Y'
1838: and asi.exclusive_payment_flag = 'N'));
1839:
1840:
1841:

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

1907: update ap_selected_invoices_all asi
1908: set payment_grouping_number = null
1909: where asi.checkrun_id = p_checkrun_id
1910: and asi.payment_grouping_number is not null
1911: and Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'Y'
1912: and exists (
1913: select*/ /*+NO_UNNEST *//* NULL
1914: from ap_selected_invoices_all asi2
1915: where asi2.original_invoice_id is not null

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

1924: -- Bug 5645890, Added the hint
1925: update ap_selected_invoices_all asi
1926: set exclusive_payment_flag = 'N'
1927: where asi.checkrun_id = p_checkrun_id
1928: and Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'N'
1929: and exists (
1930: select NULL
1931: from ap_selected_invoices_all asi2
1932: where asi2.original_invoice_id is not null

Line 6679: AND (Ap_Payment_Util_Pkg.is_federal_installed(ASI.org_id) = 'N'

6675: )
6676: )
6677: AND ASI.payment_grouping_number = rec_sel_invs.payment_grouping_number
6678: AND ASI.ok_to_pay_flag = 'Y'
6679: AND (Ap_Payment_Util_Pkg.is_federal_installed(ASI.org_id) = 'N'
6680: OR (Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'Y'
6681: AND asi.exclusive_payment_flag = 'N')
6682: ) ;
6683:

Line 6680: OR (Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'Y'

6676: )
6677: AND ASI.payment_grouping_number = rec_sel_invs.payment_grouping_number
6678: AND ASI.ok_to_pay_flag = 'Y'
6679: AND (Ap_Payment_Util_Pkg.is_federal_installed(ASI.org_id) = 'N'
6680: OR (Ap_Payment_Util_Pkg.is_federal_installed(asi.org_id) = 'Y'
6681: AND asi.exclusive_payment_flag = 'N')
6682: ) ;
6683:
6684: IF (l_count <> 0) THEN