DBA Data[Home] [Help]

APPS.AP_SSE_NOTIFY_EMPLOYEE dependencies on AP_WEB_DB_CCARD_PKG

Line 166: if (nvl(l_paid_on_behalf_employee_id, -1) <> -1 and (AP_WEB_DB_CCARD_PKG.UserHasCreditCard(l_paid_on_behalf_employee_id, l_has_creditcard))) then

162: -- Since invoices imported from expense report tables for employees have the
163: -- paid_on_behalf_employee_id populated with -1, we need to check for that
164: -- condition too
165: -- Bug 7529550 (sodash) send the notification only when the user has credit cards
166: if (nvl(l_paid_on_behalf_employee_id, -1) <> -1 and (AP_WEB_DB_CCARD_PKG.UserHasCreditCard(l_paid_on_behalf_employee_id, l_has_creditcard))) then
167:
168: -----------------------------------------
169: l_debug_info := 'Calling SSE workflow API...(paid_on_behalf_employee_id not null)';
170: -----------------------------------------