DBA Data[Home] [Help]

APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on CE_SECURITY_PROFILES_V

Line 2219: from ce_security_profiles_v

2215: begin
2216: print_debuginfo(l_module_name, 'Start YING test');
2217: select organization_id
2218: into l_org
2219: from ce_security_profiles_v
2220: where organization_type='OPERATING_UNIT';
2221: print_debuginfo(l_module_name, 'End YING test: l_org = ' || l_org);
2222: exception
2223: when no_data_found then

Line 10178: from ce_security_profiles_v cep

10174: where object_id=p_object_id
10175: and object_type=p_object_type
10176: and porg.org_id not in
10177: (select organization_id
10178: from ce_security_profiles_v cep
10179: where cep.organization_type=porg.org_type
10180: );
10181: print_debuginfo(l_module_name, 'Number of Missing Org:' ||l_org_count);
10182:

Line 11547: from ce_security_profiles_v cep

11543: 'REMOVED_PAYMENT_VOIDED')
11544: AND docs.payment_service_request_id = p_pay_service_request_id
11545: and docs.org_id not in
11546: (select organization_id
11547: from ce_security_profiles_v cep
11548: where cep.organization_type=docs.org_type
11549: );
11550:
11551: print_debuginfo(l_module_name, 'Number of Missing Orgs for rejected documents:' ||l_doc_org_count);

Line 11568: from ce_security_profiles_v cep

11564: 'REMOVED_PAYMENT_STOPPED',
11565: 'VOID')
11566: and payments.org_id not in
11567: (select organization_id
11568: from ce_security_profiles_v cep
11569: where cep.organization_type=payments.org_type
11570: );
11571: print_debuginfo(l_module_name, 'Number of Missing Org for rejected payments:' ||l_pmt_org_count);
11572: