DBA Data[Home] [Help]

APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on IBY_USER_PAY_FUNS_GT

Line 11741: from IBY_USER_PAY_FUNS_GT;

11737: -- first check whether the payment function is populated or not
11738: begin
11739: select count(1)
11740: into l_count
11741: from IBY_USER_PAY_FUNS_GT;
11742: exception
11743: WHEN OTHERS THEN
11744:
11745: /* now rows means success */

Line 11774: insert into IBY_USER_PAY_FUNS_GT(payment_function)

11770: fnd_global.user_name);
11771:
11772: if(l_bool) then
11773: --print_debuginfo(l_module_name, 'User has access to:' || l_func);
11774: insert into IBY_USER_PAY_FUNS_GT(payment_function)
11775: values(l_func);
11776: end if;
11777: end loop;
11778: close c_pay_function;

Line 11918: from IBY_USER_PAY_FUNS_GT

11914: where object_id=p_object_id
11915: and object_type=p_object_type
11916: and pfun.payment_function not in
11917: (select payment_function
11918: from IBY_USER_PAY_FUNS_GT
11919: );
11920: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11921: print_debuginfo(l_module_name, 'Number of Missing Payment Function:' ||l_function_count);
11922:

Line 13402: from IBY_USER_PAY_FUNS_GT

13398: 'REMOVED_PAYMENT_VOIDED')
13399: AND docs.payment_service_request_id = p_pay_service_request_id
13400: and docs.payment_function not in
13401: (select payment_function
13402: from IBY_USER_PAY_FUNS_GT
13403: );
13404: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13405: print_debuginfo(l_module_name, 'Number of Missing Payment Function for rejected documents:' ||l_doc_function_count);
13406: