APPS.PA_CC_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_cc_org_relationships
                        where  prvdr_org_id = x_provider_org_id
                        and    recvr_org_id = x_receiver_org_id
                        and    vendor_site_id is not null);

Line: 65

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM   pa_cc_org_relationships
                        where  prvdr_project_id = x_project_id);

Line: 157

    g_function_stack.delete(g_function_counter);