APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on CE_SECURITY_PROFILES_V

Line 2551: from ce_security_profiles_v

2547: print_debuginfo(l_module_name, 'Start YING test');
2548: END IF;
2549: select organization_id
2550: into l_org
2551: from ce_security_profiles_v
2552: where organization_type='OPERATING_UNIT';
2553: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2554: print_debuginfo(l_module_name, 'End YING test: l_org = ' || l_org);
2555: END IF;

Line 11931: from ce_security_profiles_v cep

11927: where object_id=p_object_id
11928: and object_type=p_object_type
11929: and porg.org_id not in
11930: (select organization_id
11931: from ce_security_profiles_v cep
11932: where cep.organization_type=porg.org_type
11933: );
11934: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
11935: print_debuginfo(l_module_name, 'Number of Missing Org:' ||l_org_count);

Line 13425: from ce_security_profiles_v cep

13421: 'REMOVED_PAYMENT_VOIDED')
13422: AND docs.payment_service_request_id = p_pay_service_request_id
13423: and docs.org_id not in
13424: (select organization_id
13425: from ce_security_profiles_v cep
13426: where cep.organization_type=docs.org_type
13427: );
13428:
13429: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 13451: from ce_security_profiles_v cep

13447: 'FAILED_VALIDATION')
13448: AND payments.payment_service_request_id = p_pay_service_request_id
13449: and payments.org_id not in
13450: (select organization_id
13451: from ce_security_profiles_v cep
13452: where cep.organization_type=payments.org_type
13453: );
13454: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
13455: print_debuginfo(l_module_name, 'Number of Missing Org for rejected payments:' ||l_pmt_org_count);